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?