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?

http://wordpress.org/plugins/db-toolkit/