Hi, many thanks for your response but i'm not sure i understand?
My two tables are 'RFQ' and 'CONFIGURATIONS' with a many to one relationship 'CONFIGURATIONS' to 'RFQ', so, the [Related RFQ] field sits in the CONFIGURATIONS table.
There will be multiple open/active RFQ's but when i'm working on a particular RFQ record and selecting CONFIGURATIONS to add to it the only available choice in the [Related RFQ] dropdown needs to be the current RFQ record.
Additionally, when i'm selecting records in the CONFIGURATION table, since there is no link to the RFQ table (yet) i cannot use a lookup on an Active/Closed field as it does not know which RFQ i'm working on?
