Jul 25 2005, 12:59 AM
If during defining of relationships between 2 tables I automatically get a one-to-one and i want to change it to a one-to-many, how can i do that?
Jul 25 2005, 01:04 AM
Delete the relationship.
In Table Design change the field property of Indexed from "Yes (No Duplicates)" to "Yes (Duplicates OK)" for the Foreign Key (Many Side)
Recreate the Relationship.