subform won't link to form

[lcook1974]

Hey!

I have 3 tables...

CaseReviewed: QA_ID, CasefieldID (text)
CaseReviewedDate: ReviewDateID, ReviewDate, QA_ID
CaseReviewedDetail: CaseReviewedDetailsID, ReviewDateID, irrelavant fields...

When I join the Main form (Case Reviewed) to subform(CaseReviewedDate) the master and child fields populate as I expected them to...via CaseReviewed.QA_ID = CaseReviewedDate.QA_ID

When I try to Join subform(CaseReviewedDate) [master] to it's subform (CaseReviewedDetails)[child] via CaseReviewDate.ReviewDateID = CaseReviewedDetails.ReviewDateID I get nothing.

The ID fields are autonumbers generated by ACCESS

Any ideas why it wouldn't link to the form?

Using Access 2003 (2000 file format)


Thanks!
Larry

 

[MStef]

Send a short example of your MDB (access 2000 or 2002-2003).

 

[lcook1974]

See attached...

It should open to the "frmMain"...

I have all the PK to show in the text boxes

Pick a name from the drop down
Add a date or pick a Review type

But the questions subform doesn't show the key to the Review date form

Thx for looking!
Larry

 

[MStef]

I don't understand what do you need.
In your first thread you mention 3 tables, and 3 forms (mainForm and 2 sub forms). In your MDB there are 8 tables, and 4 forms.
Be more precise, what do you exactly want.

 

[lcook1974]

Those other tables are look up tables or list tables...not really relavant to the Parent-Child issue.

The fourth form is just an add item form...not connected to the parent - child issue

One patient can have many reviews

Donald had a "pre" QA review....then the coordinator fixes the issues on the chart

Donald has another "Initial" QA review....the QA checks to see if the other issues were corrected

Donald has a "final" review...

I can't seem to get the keys to link in the sfrmMain and sfrmMainDetail.

Larry

 

[MStef]

Your "sfrmMainDetail" made of 2 tables.
Make, 1 table = 1 form (subform).
And make a RELATIONSHIPS.

 

[lcook1974]

I thought the record source was one table?

Sorry but I'm not following. Could you elaborate or send me a copy of what your talking about?

 

[lcook1974]

okay...I see what your saying.

if I take that table out of the SQL record source the ID shows up...

Why does it do that?

 

[lcook1974]

Gotta it! Thanks for the "Kick"!

Larry