Child & Master Link Fields

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

Guest

Using two different queries for two different forms. Cannot seem to link the
two forms (subform to main)
Main Form Query common field is Data.Product Title to B1.Product Title
SubForm Query common field is Data.Product Title to B1Zn.Product Title
Using Data.Product Title as the linking field but cycling thru the main for
is not cycling the subform.

These queries are 1 to 1 relationship and are separate because of the number
of fields in the second part of the queries (more than 255).

I'm sure the answer is rudimentary but so is my experience with Access 2000.
Any help would be appreciated.
 
I'm not understanding the setup that you're describing.

Post the actual SQL statement of the query that is the main form's
Recordsource, and the SQL statement that is the subform's Recordsource.
Identify the "related" fields between the two queries (in other words, which
field in the main form's SQL statement is the field that the subform's query
uses as the foreign key field).
 
Ken,

The main form query is:
SELECT DISTINCT DATA.[Product Title], B1.*
FROM DATA INNER JOIN B1 ON DATA.[Product Title] = B1.[PRODUCT TITLE];

The subform query is:
SELECT DISTINCT [DATA].[Product Title], B1ZN.*
FROM DATA INNER JOIN B1ZN ON [DATA].[Product Title]=[B1ZN].[PRODUCT TITLE];

I put DATA.PRODUCT TITLE as the Master Link and DATA.PRODUCT TITLE as the
Child Link.

When I cycle the Main form, the subform does not cycle.
 
Back
Top