All rows in a table when in forms
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?