AnsweredAssumed Answered

Extend Found Set

Question asked by director@charlesmoore.org on Jan 5, 2016
Latest reply on Jan 6, 2016 by director@charlesmoore.org

I have a database snag.  It is a simple relationship between companies and company types.

 

Based on the selection of "company type", a value list is dynamically generated of only, say, "Manufacturers".  (Acme, Widgets, and Sprockets)

 

I need to have different layout for each Company Type.

 

So in the layout here for "Manufactuers", you can see the value list correctly populates the <company_SEARCH> field with 3 values.

 

What I need my script to do is go to the selection in <company_SEARCH>, but then extend the found set to include the rest of the "manufacturers", BUT not lose the "place" of the selection.


So if the user selects "company-1002 Widgets",

 

The layout will show that record, with ALL AND ONLY the other manufacturers available for clicking back and forth to.

 

I'm adding a mock up of the database.

 

THANKS FOR ANY HELP!

Attachments

Outcomes