Ok Relationship gurus. What I am trying to do is to create a selection layout that displays all the parts in our inventory that apply to a specific car/truck. Right now I have two fields in the "Sales Orders" table 'Year' and 'Make'. The user will select one choice from each of these. I also have two fields 'Year' and 'Make' in my 'Inventory' table these fields have multiple values in them each one seperated by a carriage return. How do I create a layout that shows what parts match to the fields in my "Sales Order" table

Thanks in advance

just link salesorder::year to inventory::year and in the same pair of table occurrences, salesorder::make to inventory::make.

then in your sales order layout (based on the table occurrence used for the relationship), show a portal of related inventory parts.

regards,

Don