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?