I have the following Tables.
Field: ID, Part Number, Description
Field: PID, and bunch of other stuff for balance and inventory calculation
There is a relation between the Product ID and PID.
I have a field in a sales lay out with the following configuration.
PID control style Pop up Menu and Value from set to > Use Values from >> Product ID from Product Table and display values from second field Using Part Number from Product Table. and I have set to show Values from the 2nd table.
I want to be able to use auto complete but the option is not available. how can i make this work? maybe use a variable? or a new relation ?