Dynamic Value Lists & Multiple Data Entries......

I’ve constructed a dynamic value list, which functions thus.

There are (3) main categories defined. Under each main category are several subcategories, for example

Main Category: Nissan, Subcategory: 200SX, 280SX, Pathfinder, Altima, Maxima, etc.

Main Category: Toyota, Subcategory: Land Cruiser, Tacoma, Highlander, etc

This Dynamic Value List currently only allows entry to one set (pair) of entry fields. I need the dynamic value list to provide data entry for a maximum of five paired, separate entries in the same layout. Any ideas or suggestions will be sincerely appreciated. I can provide Table Relationship structure information if needed.

Any assistance will be sincerely appreciated.......

Daryl Murray

It sounds like you need to use another table for the selections.

Hi there,

Could you possibly elaborate on that idea ?

Thank you.....

Daryl

Instead of "five paired, separate entries in the same layout", use five (or any number of) related records in another table.

What you describe sounds very much like an invoice with multiple items (limited to five, going by your method). The items of an invoice should be individual records in a LineItems table - see an example here:

http://fmforums.com/forum/showpost.php?post/309136/