0

How to link a table to the values in a “choices” field?

I have a lookup table, it has a list of vendors. In a table of inventory items, I have a choice field called “vendor”. I’d like to populate it’s choices from the vendors table rather than by hand/static list. In this way, I can add a new vendor to the vendors table and it would be available in the inventory.vendor choice field.

Is this possible? I have added the relation of Vendors to my Inventory table.

I have SQL experience but I’m new to Ninox.

2 replies

null
    • Rob.1
    • 4 yrs ago
    • Reported - view

    I figured it out. You use the related table as the field.. cool.

    • nathan
    • 3 yrs ago
    • Reported - view

    Did you have to link them all by hand? I want to link a related table but my imported data has it as text. I'm trying to figure out the code to match the text value with the record from a table containing the same value.

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 1343Views