Table Linking Question

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Brian_Bunting_(Guest)
Posts: 3
Joined: Tue Oct 10, 2017 12:44 pm

Table Linking Question

Post by Brian_Bunting_(Guest) » Mon Jul 24, 2006 9:52 am

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
Top
carlcrespo
Posts: 7
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Table Linking Question

Post by carlcrespo » Mon Jul 24, 2006 1:02 pm

Try creating calculated fields (Convert fields to string, and trimming leading/trailing blank spaces) and join.
Top
Post Reply

Return to “R&R ReportWorks Users”