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?

 

[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!

 

[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.