Enter new record on a form with subform

[jpkeller55]

I have a table that has patient names (ptTbl) and demographic information. I have another table (commentTbl) that holds comments for each patient by date. The tables are linked by patient ID number (ptID). (Referencial integrity is checked on table relationships). I have a form that has the patient demographic data on top and a subform below with the comment entry.

This all works fine until I try to add a new patient (top section of form). For some reason I cannot figure out how to do this. Anybody know the answer?

 

[jpkeller55]

I figured it out...need to get rid of the Referential Integrity and now it works fine.

 

[TheAceMan1]

How are ya jpkeller55 . . .

[blue]I figured it out...need to get rid of the Referential Integrity and now it works fine.[/blue]

Hate to be the one to say it . . . but if removing [blue]referential integerity[/blue] made it work . . . then somethings wrong! or there's something you havn't explained yet . . .

Did you use the form wizard to setup your form with subform?

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[jpkeller55]

Hi Aceman,

Yes I restructured the forms using the forms wizard on the subform entry after removing the referential integrity. It seems to work fine now. I assume the wizard has accounted for this somehow?