I am working on an inventory database in access. The problem I have is that I have parts that each have unique info and those parts then get packaged into a cell. I am trying to find a way to display all the parts that go into a specific cell.
I currently have a table partT that has the partID, date, and other info I also have a cellT that has cellID, assembly date, and other info
I want to have a way to see the partIDs that are associated with a specific cellID
I have created a third table that links the cellID and partID fields and defined the relationships between these tables. This gives me a subdatasheet in the cellT that does show the associated partIDs. However, I would like to display this information in a continuous form to easily see what parts are associated with a cell (that is to say I would like to put all the partIDs for a single cellID into one text box on the form).
