creating drop downs and portals
i have 2 tables: (vendors) (product)
In the (product table) i'd like a drop down menu that is based on the field "company name" in the (props table).
When I create a record in the (product table) and select a company name (based on the records in the vendors table), I'd like to create a relationship between the record I just created and the corresponding record in the (vendor table).
With that relationship, I'd like to create a portal in the (vendors table) so that I can see a list of records that have the same company name as the records in the (product table).
How do I do this?