How to change a relationship?

[desibasha]

i have a one to one relationship
I need it to be one to many.

how can i change this?

 

[Pat Hartman]

Jet determines the relationship automatically by evauating the primary keys of the related tables. A relaionship is 1-1 when the tables are related on all fields of their primary keys. If you want to change the cardinality of the relationship, you must change the table structure so that the keys are properly defined.

 

[desibasha]

got it thanks!

i had to change one of the fields in the table to be indexed w/duplicates...and now its one to many as i wanted

thanks again!

 

[Pat Hartman]

Your table is still not correct. Each table should have a unique primary key. If you don't have a single field that will be unique, you can use a combination of up to 10 fields OR you can add an autonumber and use that.

 

[Mike375]

Don't forget to make sure those fields are truly unique. If not you might one day run append queries with warnings turned off and any dupicate won't make it across.