have you tried to enable <enter> as a way to go to the next object ? (in layout mode, Inspector, data tab, go to next object using...)
It's not a question of going to the next object, it's being able to choose from two drop-down fields and having one update the other.
If you don't have 2 products with different ID and same product description, all you need is to executeSQL your product database with the product description on product description modify, grab the corresponding ID and set the product ID to it.
Use Get(ActiveFieldName) in auto-enter calculation, to determin where user enter the data.
For ID field
Case ( Get(ActiveFieldTableName) & "::" & Get(ActiveFieldName) = GetFieldName ( Self ) ; Self ; Products 2::product_ID )
tableToEnter::description = Products 2::product Description
This mean "If user enter (or select since you use dropdown for the field) ID, keep the value as entered, else LOOKUP with description".
Same on Description field
Case ( Get(ActiveFieldTableName) & "::" & Get(ActiveFieldName) = GetFieldName ( Self ) ; Self ; Products::product_Description )
tableToEnter::ID = Products::product ID
I believe this is exactly what I am looking for. I will report back shortly after I've tried it.