referential intergrity

[Guest]

Hi,

I have database that i am trying to enforce referential intergrity when i
update a filed in one form. the two forms are in a one to one relationship.
but not every record in form A has a record in form B. does this make it
impossible for me to enforce referential integrity? if not, how do i go
about this?

 

[Jeff Boyce]

Russ

Access provides the mechanisms for setting/enforcing referential integrity
between tables, not forms.

Can you provide a bit more description of the underlying data/table
structure?

 

[Roger Carlson]

First of all, let's get our terms straight. Forms do not have
relationships. Tables do. So I am assuming that you have two tables TableA
and TableB, each of which has a form bound to it.

Now, it is certainly possible to enforce referential integrity between two
table in a One-To-One relationship. However, I have rarely done so. In
fact, I rarely use a 1:1 relationships. Most of the time, it is more
efficient to have all of this information in one table. (Table level
security is one exception.)

It would be helpful to know 1) why you are using a 1:1 relationship and 2)
what are the actual table and field names (and datatypes for the fields).
This would help us to better understand your situation and solve your
problem.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L