AnsweredAssumed Answered

Add Records to related Pop-Up menu

Question asked by leonaisse on Feb 13, 2013
Latest reply on Feb 13, 2013 by philmodjunk


Add Records to related Pop-Up  menu



I have a Pop-Up menu that uses a value-list from a related table to display the supplier but store the ID. I'd like to have the ability to add new suppliers but when i "Allow entry of other values" I get an error as the popup-menu is expecting a number for the relationship rather than the string of a supplier name. My tables are:

SUPPLIERS = ID, Supplier Name

PRODUCTS = ID, ProductName, SupplierID

Whats the best way that will allow me to add to the suppliers table but store the supplierID in the products table?