I'm using FMP 8 on a PC.

My situation is as follows:

I am trying to set up an order form with 5 "Categories" of items -A, B, C,
D, E
There are 10 "Items" within each category

I have the 5 categories drop down in a list when I click the 'category'
field. No problem there.

However, I'd like for ONLY the items that are related to that category to
drop down in the next field, 'items', not all 50 items.

What do I need to do? I have a moderate knowledge of FMP.

Is there a sample of a simple ordering database available so I can get some
ideas on how to set one up?

Thanks in advance.
KS

In article <dSJKh.3034$Hb2.1621@trndny02>, "KennyS"
<ks4078 (AT) hotmail (DOT) com> wrote:

You need to set-up what is called "Dynamic Value Lists".

To do this you first need to create another Table (ItemsTable) to store
all the possible combinations of values for both Pop-up List fields.
This means creating a table that has both a Category and Item field,
and then creaating new records within that table for every combination.
eg.
Record 1: Category = A Item = Banana
Record 2: Category = A Item = Apple
Record 3: Category = A Item = Grapefruit
Record 4: Category = B Item = Space Shuttle
Record 5: Category = B Item = Moon Lander
etc.

Once you've done that, you can define a new Relationship in the
original Table (MainTable) that matches the Category fields in the two
Tables.
ie.
ItemRelationship From MainTable to ItemsTable
when Category = ItemsTable::Category


Then you create (or change) the Items Value List to obtain it's values
from the Item field in the ItemsTable via this Relationship. Lastly
make sure the Items field in the main table is using this Value List
for it's Pop-up List.

Now when a user chooses "A" from the Category Pop-up list, the Item
field will only contain the choices: "Banana", "Apple" and
"Grapefruit".


There is a problem when using these Dynamic Vlaue Lists though - users
MUST enter the Category first, otherwise the Items Pop-up List will not
display the correct values.

They also make performing Finds on the Item field more difficult. To
get around this you have to create a specific "Find" Layout where the
Item field uses a different Value List definition which simply contains
ALL the possible Item values.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

On 03/17/2007 00:09:45 "KennyS" <ks4078 (AT) hotmail (DOT) com> wrote:

See http://www.VirtualVermont.com/FMP for an example of how to do this.

Second item: Dynamic Value List.

Matt

At this point in time the server seems to be off-line...

Keep well, Ursus

On 03/17/2007 11:03:45 "Ursus" <ursus.kirk (AT) wanadoo (DOT) nl> wrote:

Working fine for me...

Matt

THANKS to all of you. I think I've got in now.
KS
"KennyS" <ks4078 (AT) hotmail (DOT) com> wrote