Referential integrity and forms

mctaguma

Registered User.
Local time
Tomorrow, 10:21
Joined
Dec 30, 2006
Messages
18
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.
 
Hi mctaguma,

Unless I am missing something, I see no tables in the back end?????:cool:

Robert88
 
They're hidden :)

Goto Tools - Options - View - Hidden Objects
 

Users who are viewing this thread

Back
Top Bottom