Hi all,
Many thanks for all the help thus far with my Scout Database
I have a problem with referential integrity, I am getting errors.
In my form 'frmHeader' , when I select a member, and click achievements (a command button in top right corner) i always have to enter a date, it never creates a record in VenturerDetails (table) for a Venturer.
When it goes to frmVenturerAchievements (for a Venturer) I get referential integrity errors when I enter data into the subforms.
Scout Database
I am experimenting with a Scout and a Venturer.
Any help would be much appreciated
Many thanks in advance,
Matthew
P.S. I'm using MS Access 2003 to design it.
Many thanks for all the help thus far with my Scout Database

I have a problem with referential integrity, I am getting errors.
In my form 'frmHeader' , when I select a member, and click achievements (a command button in top right corner) i always have to enter a date, it never creates a record in VenturerDetails (table) for a Venturer.
When it goes to frmVenturerAchievements (for a Venturer) I get referential integrity errors when I enter data into the subforms.
Scout Database
I am experimenting with a Scout and a Venturer.
Any help would be much appreciated

Many thanks in advance,
Matthew
P.S. I'm using MS Access 2003 to design it.