Exclusionary Value List

[Jhancho]

Hi all.

I'm looking for some guidance on this problem.

When a user creates a job in this database, I'd like the operations that person chooses (in a portal) to disappear from the value list once assigned to that job.

Currently, the database is set up with the operations and jobs with their own tables, and are joined by a table called operation estimates, which takes both primary keys from the other tables.

I've scourged the internet and forum sites, but can't seem to find much information on this type of list. I'm sure it has to do with conditional value lists and table occurrences, and just recently I've wrapped my head around that, but any help would be greatly appreciated!

[comment]

See here:

http://www.fmforums.com/forum/showtopic.php?tid/185835/

[Jhancho]

Thanks a ton comment!

It works like a dream.