Populating Relational Data
-
I’ve created a relational database, for simplicity sake, let’s say Inventory and Line Items.
There is one Item in inventory and many possible line items for an invoice.
Has anyone discovered a way to join and populate the relational fields?
Ideally, I’d like a text box where you start typing in the product name which it checks against the inventory table. Haven’t seen a way to do this yet, so I just created a text field entry.
If I create a Filtered Join Table to pull the other information based on this text field, it only gives me a pulldown menu, not an auto population of the related information.
Anyone have suggestions?
- The topic ‘Populating Relational Data’ is closed to new replies.
