I have a Form and a SubForm which have 2 tables associated with them.
When I build a query linking the 2 tables, the data in the main table comes in multiple rows, each row having the different data of the linked or child table. I want the child table data in separate columns instead of rows and only one row of the parent table for each record
In the enclosed DB I have 2 tables and one query linking the 2 tables.
I searched the internet and forum but could not find anything similar which could address this requirement
Is this feasible?