Query doesn't display info

[Eddy Sincere]

Sorry for the crappy title, but I have no idea how to describe what I'm seeing. I have a table that is essentially a formula. It takes items A, B, C and D combines them into something like this:



Parent Child Quantity
A B 0.5
A C 0.4
A D 0.1

Where A is the parent item number and B, C & D are the children. I store both the parent and child item numbers in the same table because they have an identical structure, i.e. item number and description.

Here's my problem, I created a query bound to a form to enter information into a table. The three critical pieces of information are the Parent and Child item numbers and quantity. However, when filling out a form it's nice to have the item description so that you have a visual check so I tried to drop in a description field for both the parent and child item numbers. But, the query will deliver the description for only the Parent OR the Child items, not both.

Two Tables are: ItmNmbrs and tstCSpc
Query: qryTblTstCSpc

I attached the DB for reference.

Also, If you open the switchboard (sbSpc), click on the green button "Composition" you can see the type of form I've going for. I'm trying to switch to query because the boxes with the descriptions are hooked to the combo box queries and we figured out in a previous post that they were giving me errors (Thanks Steve HTH & June7).

Specifications18 - MSF.zip

[June7]

Include the ItmNmbrs table in the query twice. One each link to a field in tstCpc.

[Eddy Sincere]

I knew it! I freakin' knew it was something easy that I just couldn't find. As always, thanks for the help and (very) quick response. You're a life saver.

Problem solved!