UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Change relatoionships    
 
   
mike1981
post Jul 25 2005, 12:59 AM
Post #1

UtterAccess Addict
Posts: 162
HI.
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?

Thanks
M.
Go to the top of the page
 
+
MicroE
post Jul 25 2005, 01:04 AM
Post #2

UtterAccess VIP
Posts: 4,034
From: NY - USA
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.
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 25th May 2013 - 06:40 PM