1 Reply Latest reply on Feb 13, 2013 7:07 AM by philmodjunk

    Add Records to related Pop-Up menu

    leonaisse

      Title

      Add Records to related Pop-Up  menu

      Post

      Hi

      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?

      Thanks

       

      leonaisse

        • 1. Re: NoFields
          philmodjunk

               Add a button to your layout that uses a script to add a new record to your table of values. Adding the new record will automatically add it to the value list. The script can change to a different layout, open a custom dialog or use new dialog to open a small window where the user enters the data for the new value.