I have two tables and I combined those tables into one query.
Table1 fields:
Number, Type, discipline
Table2 fields:
Number, Account, Bill, Requester
Table1 & 2 are joined in the query where all the records from 'table1' and only those records from 'table2' where two fields are joined.
The query looks like this:
Number Type Discipline Account Bill Requester
0001 A pipe
0002 G pipe 4567 45678 Ham
0002 G pipe 3678 36789 Ham
0003 B pipe
I only have three records total in table1, and two record in table2, both that apply to 0002.
how can i create a form based on the query that shows only one of the duplicated records. I want the total number of records in table1 to match the total number or records in the query.
Table1 fields:
Number, Type, discipline
Table2 fields:
Number, Account, Bill, Requester
Table1 & 2 are joined in the query where all the records from 'table1' and only those records from 'table2' where two fields are joined.
The query looks like this:
Number Type Discipline Account Bill Requester
0001 A pipe
0002 G pipe 4567 45678 Ham
0002 G pipe 3678 36789 Ham
0003 B pipe
I only have three records total in table1, and two record in table2, both that apply to 0002.
how can i create a form based on the query that shows only one of the duplicated records. I want the total number of records in table1 to match the total number or records in the query.