Joining with more than one field

[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.__

[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