July 28, 200817 yr Newbies 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!
Create an account or sign in to comment