I have two tables called Table A and Table B.
Table A has a autonumber as primary key and the table is updated manually. Table B is linked to an Excel file (where data is downloaded daily from our system) and has no autonumber primary key.
There is one field in both tables called POS_NUM that are identical. I want to build a report based on Table A, with a subreport based on Table B. The parent/child link is on the POS_NUM field.
I created a query with both tables and joined the tables by POS_NUM. When I run the query, it appears to capture the data I need, but with a glitch I can’t seem to fix.
In Table A (not Table B) there are some position numbers that have more than one person assigned to it. In those cases, my data doesn’t capture the individual names of all those assigned to that particular number. For example, if my query pulls position number R0300 and 3 different people are assigned to it, three records are pulled, but the same name is identified for all three records. In my Table A data, this is the name of the first person assigned to it, but there are two other persons assigned as well.
I need my query to pull records for each unique position number, and for those position numbers with multiple persons assigned, to identify each of those records with the unique names of all those assigned.
Appreciate the help.