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
 
Back
Top