Allow multiple form fields to populate the cabinet fields based on the answers provide.

IE
Product List 1 - Empty
Product List 2 - Empty
Product List 3 - Product 1

Allow them all to be linked to a PRODUCT field but allow some form of arithmetic expression (IF Statements) to populate it.

Iif(Product 1="Product 1",Product 1,Product 2)

Something along those lines. Its frustrating having to create fields to import data back and forth.