AnsweredAssumed Answered

creating drop downs and portals

Question asked by seangarrett on Jan 27, 2011
Latest reply on Jan 27, 2011 by philmodjunk

Title

creating drop downs and portals

Post

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?

THanks!

Outcomes