Page 1 of 1

Table Linking Question

Posted: Mon Jul 24, 2006 9:52 am
by Brian_Bunting_(Guest)
Is it possible to link two tables off of a concatenated field?____Table 1 and Table 2 both contain an order number field and an invoice part number field, and I want to create a concatenated field in both tables (ordernumber:invoicepartnumber) and then link off of that field.____Thanks

=> RE: Table Linking Question

Posted: Mon Jul 24, 2006 1:02 pm
by carlcrespo
Try creating calculated fields (Convert fields to string, and trimming leading/trailing blank spaces) and join.