>Hi everyone,
> I was wondering if there is a way to put a relation on two fields instead of one. I am dealing with two tables, TableA and TableB that have the two fields that are the same, model_no and order_no. TableA has order info and is the RecordSource for Grid1. TableB has serial numbers and is the RecordSource for Grid 2. The problem I am having is when I select any record from Grid1 that has an order that might have the same model_no as a different record, grid2 will display all the serial numbers and not just the ones that belong to that record. I know I could create a unique number to solve this problem but if I can just use the model_no and order_no fields I won't have to go through the two tables adding that new unique number. Can anyone help me?

Permanent relations, for RI, are from index to index.

If it is for the SET RELATION command, or the equivalent relation between grids, the relation goes FROM an expression, TO an index.

In any of these cases, you can use an expression on more than one field. To concatenate more than one field, all non-character types should usually be converted to character.