Hello,
The attached database contains a portion of a larger one. the tables are the ones giving me the issue, forms are also included to show how I am entering the data. The table represents various components that go into a product. Originally I had 6 fields of 1 of the components because up to 6 could be used. I took those out and put them into their own table to eliminate redundant fields, then created a link table to tie all 3 tables together.
After placing a subform in the original form and checking the content of the new table, everything looks correct as far as the data goes.
I cannot build a query that gives me the desired results. I have attached a spreadsheet of what I would like the results to look like. I want to be able to create a report based on the query.
All other parts of the original database are working great. This is just the first time I have had to break out a table like this and create a link table and I am not sure how to set up the query correctly.
The tblM22368-2 is the main one tblM22368LinkM13472 is the link table and tblM13472 is another table that I am pulling the M13472 Lot number ID from that gets placed in the tblM22368LinkM13472.
Can someone please help me out with ths
Thanks
Dave
Query Issue Spreadsheet.zip
Query issue-Progress.zip