I have two tables List and Mix

List has two field ID (number) and Name(text) . It lists Contracts by ID and name all records unique.

Mix has four fields (ID1, Name1, ID2 Name2)which state which contract can interact with which other contract...... when ID is entered then the name fields auto enters via lookup relationships to the List table

For data entry and checking I have a layout for List as a form which contains a portal showing records from Mix related to the current contract ID to show which contracts have been designated as combinable with the ID in the current record.

But these portal records only show based on one relationship.... thus if 2 and 6 are permitted to combine and entered as ID1=2 ID2=6 it is only viewable when looking at the layout where ID::List =2 not from viewing the faorm where ID::List=6

The solution I am trying to find is to create a script that can take the current record and create a new record with the data from ID1 used as a value for ID2 and vice versa... so the user creating a record with values ID1=2 and ID2=6 would automatically also create a second record in the same table with the

values ID1=6 and ID2=1

In Mix create a text calculation of ID1 &