I've run into a bit of a wall and am hoping someone out there can help me out with this problem.
I have two tables, PEOPLE and PRODUCTS, each with about 100 records. For every PERSON, each of the individual PRODUCTS needs to have a status (three set values: "for sale", "pending", "not available"), plus a notes field. Each PERSON will have different statuses and notes for each of the individual PRODUCTS.
Normally, I would simply use a portal and join table to select the product, set the status, and the note.
I'm hoping there is an easier way to do this. If I'm in a layout based on the PEOPLE table, is there a way to have a portal that lists all of the PRODUCTS with a radio set for the status and a notes field? Upon selecting a status, can it create the join record?
Is there an easier way to do this? I'm looking to avoid the user having to select each product when creating its status/notes.
Thanks so much for any help you can offer!