table relationships (1 Viewer)

[reyrey]

i have 2 tables that share a one to one relationship. the problem is that when i enter the data into a form, i get an "unable to add or change data in table1 because of related data in table2. it seems there is a "must have" relationship between the 2 tables, when i really need a "may have" relationship between the two. is this changed in the properties tab? how can i tell by looking at the relationships? oracle uses a hashed mark connecting the two tables for "may have" and a solid line for "must have". my tables have a single solid line connecting them. thanks

 

[boblarson]

So, does the first table have a primary key which is linked to a FOREIGN KEY on the other table? You do not want to link primary keys.

 

[spikepl]

Doubleposted here: http://www.access-programmers.co.uk/forums/showthread.php?p=1161405#post1161405

Please do not doublepost

 

[reyrey]

boblarson, i'm not sure i understand your question. the primary key on the parent table is the foreign key on the other. there is nothing linked to the primary key on the child table, if thats what your asking.

 

[Pat Hartman]

I gave you the answer in your other post.