Hoping someone can help me with this, my access stuff is a bit rusty.
I'm working on something where there is a table for primary jobs, with an associated table with sub-jobs on a one to many relationship. Each sub job has a completed yes/no entry, as does each primary job.
What I want to do is to make it so you cannot set the complete field in the primary job table to yes if there are linked sub jobs where the complete field is set to no.
Any thoughts on the simplest way to do this?
I'm working on something where there is a table for primary jobs, with an associated table with sub-jobs on a one to many relationship. Each sub job has a completed yes/no entry, as does each primary job.
What I want to do is to make it so you cannot set the complete field in the primary job table to yes if there are linked sub jobs where the complete field is set to no.
Any thoughts on the simplest way to do this?