Auto-Complete challange

Discussion created by ohannis on Aug 7, 2013
Latest reply on Aug 8, 2013 by ohannis

I have the following Tables.


Table: Product

Field: ID, Part Number, Description


Table: Balance

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 ?