D
Denise
Database has 2 tables in 1-1 a relationship because one table has
confidential information. The PK is the same for both tables. Problem: Person
enters data in table 1 (public) and forgets to enter in table 2 (non-public),
then Access cannot find the record when I search using query that includes
both tables. I would like to find a way to force entry of one field in table
2. I can't rely on data entry staff to remember to do this on their own.
Data entry is by form.
confidential information. The PK is the same for both tables. Problem: Person
enters data in table 1 (public) and forgets to enter in table 2 (non-public),
then Access cannot find the record when I search using query that includes
both tables. I would like to find a way to force entry of one field in table
2. I can't rely on data entry staff to remember to do this on their own.
Data entry is by form.