Update Query across 3 tables (one -to - many)

[kellyputty]

The following tables:

Clients:
ClientID(P autonumber)***
LastName
FirstName
SSNum

AcademicEducations:
ClientID(F , number, long integer)****
HighestObtained
AcademicEducationsID (P autonumber)

Institutions:
ClientID(F , number, long integer)****
Where
StillAttending
InstitutionsID(P autonumber)

When I update anything in the Institutions table AcademicEducations.ClientID looses its value ( it turns to zero from it's previous "correct" value). This results in violating referential integrity. Anyone know why that is?

I think it might be because I have to save the table on the one side of the one-many relationship first. Does anyone know how to do that?

Thanks,
KellyPutty

 

[PHV]

Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886