Linking table/query SQL

[Gary T.]

I have a table called tbl_QuoteDetails
QuoteNo Prim Key
fkeyProductID foreign key
Paneltype
Length
Price

Another table called tbl_Product:
ProductID Primary Key
ProductName
Thickness
NumbInPack

This contains essentially set data ie
ProductName Thickness NumbInPack
ABC 12 3
ABC 15 7
DEF 11 5
I created a blank form and added the above mentioned tables in this form as
subforms.
When entering new data into these subforms, I merely click the FkeyProductID
(combo box) field which gives me a dropdown multicolumn list.
eg. ProductID ProductName Thickness NumbInPack
the combo is bound to column 1 - the productname

It then allocates automatically the particular row data (selected in the
multicolumn combo box) in their respective fields.
So then ProductName, Thickness and NumbInPack fields will be automatically
populated by the choice made in the combo box.
Question: I want to combine all fields from both tables as one subform where
I can select the fkeyProductID multicolumn combo box and when selecting the
row line in the dropdown box, it will populate the respective fields with
this choice.
I tried a query and it didn't work. I can't seem to even enter data when
having created that query incorporating the fields from both tables.

[pietlinden]

Looks like your standard Invoice/InvoiceDetails setup, except you don't
seem to have an invoice table. So that would be your main table, and
then your subform would be based on InvoiceDetails

InvoiceDetails
InvoiceID
ProductID
Quantity
Cost
(and then in your query) Partial Cost = Quantity * Cost (or as complex
as you need). And then you're pretty much set. If you are having
trouble with it, take a look at Northwind and modify it to suit your
needs.