Page 1 of 1
Joining with more than one field
Posted: Sun Jul 20, 2008 10:06 am
by Childers_(Guest)
Is it possible to create a join with more than one field, in R&R SQL? A composite key can be created in the main table, but I don^t see how to create a calculated field with a composite key in the related table.____Will this require defining a primary key? The problem is that I can^t change the structure of the database.__
=> Joining with more than one field
Posted: Mon Jul 21, 2008 10:11 am
by kfleming
You can select a list of join fields for the report.__So to join on Company LastName, you would first select Company from the parent and the related table. Then click the Options button in the Join dialog. This will open up a list box below the join fields and will allow you to select the second join field LastName from the parent and related tables.__You can repeat this for as many fields as you require.____Kathleen__R&R Support