AnsweredAssumed Answered

FM11 - Conditional Value Lists

Question asked by chawks1995 on Jul 15, 2011
Latest reply on Jul 17, 2011 by Dave Graham


FM11 - Conditional Value Lists


Hello All,

I have a problem with getting my conditional value list to work correctly.

My FM database is setup as follows:

Tables (3):

Orders Table - Primary Key, kp_OrderID, Foreign Keys, kf_ManufID and kf_MaterialID

Manufacturers Table - Primary Key, kp_ManufID

Materials Table - Primary Key, kp_MaterialID, kf_ManufID

(Join is based via the Orders Table's Foreign Keys to each of the other tables's primary keys, Add Records via this Relationship is selected)

Desired Functionality:

When on the Order Form the user will first choose a Manufacturer from a drop-down menu. This list is based on all records found in the Manufacturer's table. The drop down menu selection is stored in the kf_ManufID field which is on the Order Form. Next, and this is where I am having some trouble, the user will proceed to select a Material (Part Number) from a drop down list assigned to the field kf_MaterialID on the Order Form. It is desired that the value list assigned to this field would display only those materials belonging to the manufacturer selected from the previous drop down menu.

For some simple reason I am sure, this just doesn't work - the value list for the materials is always blank irregardless which manufacturer you select from the previous field.

Any input would be much appreciated - thanks in advance!

[Sketch attached for Reference]