indeterminate relationship

[Guest]

I'm trying to make a relationship between two tables,in the relationship type
section it gives me that the type of relation is "indeterminate ,how can i
make it "one to many" ?

 

[Steve Schapel]

Pietro,

In order for it to work as a "one to many" relationship, the joining
field in the table on the "one" side of the relationship needs to be
uniquely indexed. In most cases, this means it will be the Primary Key
field in this table.

 

[Guest]

Thank you for your reply
the joining field in the table on the "one" side is a "primary key" but the
other table that represents "many" is a table linked to the inbox of
Outlook,so i cannot change a value of it,can you help ?

 

[John Vinson]

Thank you for your reply
the joining field in the table on the "one" side is a "primary key" but the
other table that represents "many" is a table linked to the inbox of
Outlook,so i cannot change a value of it,can you help ?

How on Earth can you expect Access to be able to *enforce* a
relationship if it cannot control the values entered into the many
side table? Access is not Outlook, and an Access relationship cannot
control what is or isn't entered into the Outlook inbox!

John W. Vinson[MVP]

 

[Guest]

Daer John,
No it can ,I have already solved the problem !!!
Thank you