Hi all,
I have two tables and require the records to appear when I run a query. One field of from a table called CLI and the other is called Equipment. I require the field AccountNo from the CLI table to correspond with four fields from the Equipment table. The equipment form is a corresponding form but when I run the query it only takes the first record and not all. I have added some screenshots and am hoping someone may be able to help.
I have two tables and require the records to appear when I run a query. One field of from a table called CLI and the other is called Equipment. I require the field AccountNo from the CLI table to correspond with four fields from the Equipment table. The equipment form is a corresponding form but when I run the query it only takes the first record and not all. I have added some screenshots and am hoping someone may be able to help.