PK and FK not working together

[JOEYB99]

I'm using Access 2007.

For a main table I have a PK that is auto-number, long integer. For other_table I have created and designated a field as an FK, called it the same name as the PK, and made it long integer.

In the Relationships I have linked these tables using PK to FK, and turned on referential integrity.

I made each of these tables into forms and they each work fine, just as they are supposed to. No problems.

I make the other_table a subform of the main form, place it in the Details section, and link them as PK to FK. I get blank results in the subform when I select Form View.

Arghhh! Why is that? what am I doing wrong?

Can someone please help me out? I am at wit's end!

 

[dhookom]

What are the record sources of the main and subforms as well as the Link Master and Link Child properties.

Duane
Hook'D on Access
MS Access MVP

 

[JOEYB99]

Thanks dhookom.

The Link Master and Link Child have the PK and FK fields in them. I was aware of this when I went through the Form Wizard.

The record source for the main form is the main table, and the record source for the subform is the other_table.

Can you suggest anything else to check?

 

[dhookom]

I wouild check the various data properties of the subform. Can you add records?

Duane
Hook'D on Access
MS Access MVP

 

[JOEYB99]

No hookom, I am unable to do any input. I am going to try to send a screen print.

 

[dhookom]

You can't attach files in TT. You need to upload the file to a website and provide the URL. Many of us can't access these sites from work PCs.

Duane
Hook'D on Access
MS Access MVP