How to auto-populate records in query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a master query named "qryMaster" with 3 fields of MasterID
(AutoNumber and primary key), CategoryID and SizeID.

I also have 2 other queries:
1) "qryCategory" with 2 fields of MasterID and CategoryID (AutoNumber and pk);
2) "qrySize" with 2 fields of CategoryID and SizeID (AutoNumber and pk).

How do I link SizeID's in qryMaster and qrySize, such that all SizeID
records entered in qrySize automatically populate the corrosponding SizeID
field (with the same MasterID) in qryMaster? Each query is based on its own
table.

Thanks
 
Plz ignore the previous post because the intended question is slightly
different. Here is what the question should be:

I have a master query named "qryMaster" with 5 fields of MasterID
(AutoNumber and primary key), CategoryID, TypeID, SizeID and SizeName.

I also have 3 other queries (these are also used to define the respective
combo box list in a form elsewhere):
1) "qryCategory" with 2 field of CategoryID (AutoNumber and pk).
2) "qryType" with 4 fields of CategoryID and TypeID (AutoNumber and pk);
3) "qrySize" with 6 field of CategoryID, TypeID, SizeID (AutoNumber and pk)
and SizeName.

How do I link SizeID's between qrySize and qryMaster, such that all SizeID
records entered in qrySize automatically populate the corrosponding SizeID
field (with the SAME CategoryID and TypeID and SizeName) in qryMaster? Each
query is based on its own table.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top