value list that includes only related field values???

[dh003i]

FileMaker Pro 8's help on this is useless....

 

Here's what I'm trying to do.

 

I have three tables that are relevant to this issue, I list them with the table in CAPS, and some relevant fields immediately below it:

 

VENDORS

Vendor

Address

City

State

etc.

 

PRODUCTS

Item

Vendor

CatalogNumber

Description

etc.

 

ORDERFORM

Vendor

Item

 

Right now, I have the ORDERFORM table set up so that Vendor and Item are pull-down menus. After the user selects a Vendor in the Order Form View, that view displays that vendor's relevant contact information (fields displayed from the VENDOR table). After the user selects a Item in the Order Form View, that view displays that item's catalog # and description, etc.

 

So, here's the problem. The way I want to do this is that first user's select the Vendor they want to order from, then they can ONLY select Items from that vendor. Right now, users could select one vendor in an entry on the ORDERFOR's view, and then an item that's from a different vendor (hence, that record would be invalid / incorrect).

 

What I want filemaker to do is to, when displaying possible Items that the user can select for the Order Form View, only show those items that are from the Vendor that user has already selected. How do I do this?

 

The way I have my tables linked up is as follows:

 

VENDOR is linked to ORDERFORM via that Vendor field.

PRODUCTS is linked to ORDERFORM via the Item field.

[Inky Phil]

Link Order form to order form via the vendor field and set your value list to show related records only based on (starting from)that relationship

 

HTH

Phil

[dh003i]

I already tried that, and it doesn't seem to work. So, I had the following

 

ORDERFORM linked to VENDOR by Vendor field

ORDERFORM linked to PRODUCTS by Item field

ORDERFORM linked to ORDERFORM2 by Vendor field

 

and an Items list, defined to list things from the PRODUCTS :: Item field, showing only related values starting from the ORDERFORMS2 :: Vendor field.

 

But, it still didn't work. After selecting Vendor in Order Form View, it wouldn't show me any Items at all. Any idea why?

 

PS: Also, if I tell the list of Items to display only related value starting from the VENDORS :: Vendor field, it will narrow down the things, but will only show Items previously ordered from the Order Form View, not all Items from that vendor.

[dh003i]

and an Items list, defined to list things from the PRODUCTS :: Item field, showing only related values starting from the ORDERFORMS2 :: Vendor field.

 

But, it still didn't work. After selecting Vendor in Order Form View, it wouldn't show me any Items at all. Any idea why?

 

PS: Also,

 

Correction, it didn't work, but in the same way that the other method I specified in the PS didn't work: If I tell the list of Items to display only related value starting from the ORDERFORM ORDERFORM2 relationship (linked by Vendor field), it will narrow down the things, but will only show Items previously ordered from the Order Form View, not all Items from that vendor.