I need to require a field in one table to be filled in to allow entries in another table
Posted on 2004-08-10
Hi, I'm using Access 97. I have a Jobs table that has an autonumber Job Number field, a lot of other fields, and a Completion date field. This is only filled in when a job is finished. I also have a Billings table, which has a Job field that links to the Job Number field in Jobs table. I need to set my database up so that you can only enter information in the Billings table if the related record in the Jobs table has a value in the Completion date field. Any ideas? Thanks a lot.