AnsweredAssumed Answered

Set Status by Portal with ALL records in a table?

Question asked by multisonic52 on Sep 15, 2016
Latest reply on Oct 17, 2016 by multisonic52

Hi there:


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!