I have two tables, tblCustomer and tblJob, with many jobs to one customer. tblJob contains JobNo and CustomerID which relates to a field of the same name in tblCustomer. All the fields are Numbers. I have a form to maintain each table. On the job form I have a Command button to add a job, but I cannot see all the job numbers in use because they’re restricted to the jobs for the current customer, which is open in a form in the background. How do I see ALL the job numbers in use please?
Regards,
Nigel.

If you want the jobs in the subform to reflect all jobs and not just the one for that customer, you must go to the properties of the subform (in design view) and remove any parent/child links from the form to the subform.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks for your contribution, but I didn't make it clear what I wanted. I want to add a new job with a new jobNo that's not been used before by any other customer, and for that I have to 'see' jobs regardless of customer. The other alternative, I suppose, is to keep the last used jobNo in a master table then the next jobNo would be 'last_used_jobNo + 1' each time. Generally speaking, the relationship between customer and jobNo is useful to show what I did for whom. Hope that makes sense. Nigel.