Hi Guys:

I have a portal that holds a value list that it populates from another table. I would like to have the list to filtered if the value has been selected in the portal, so it doesn't repeat itself. For example If I have Machine 1, Machine 2, etc... and select Machine 2 in my first record in the portal when I create the second record it will take Machine 2 from the value list. My relationship is as follows.

Shift Table

kp_shift_id

.....

Machine table

kp_machine_id

......

Transactions table

kf_shift_id

kf_machine_id

....

Shift and machine table are already related to my transactions table in the relationship graph. My value list right now is being populated from the machine table.

Thanks guys in advance for your help.

Andres Dominicci

Edited September 17, 201114 yr by Andres Dominicci

See if this helps:

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

Thanks a lot, it worked based on the last file you posted in that thread. :laugh2:

Andre