Problems updating form based on query

[weezles]

Hi

I have two tables tblOne and tblTwo linked by RefID on a one to one relationship and without referential integrity enforced. I have a form based on a query which joins these two tables showing all fields.

I can update information in the form which is stored in tblOne but not in tblTwo.

Any suggestions on why this doesn't work?

Thanks

Lou

 

[PHV]

I have a form based on a query which joins these two tables showing all fields
Even tblTwo.RefID ?

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

 

[weezles]

Hi PH

I've just tried the query without tblTwo's RefID but its still the same whenever i try to change or add something it resets tblOnes RefID to 0 and gives an error on duplicate PK's

Lou