D DC27 Registered User. Local time Today, 08:40 Joined Jun 6, 2008 Messages 27 Jun 6, 2008 #1 Is there an obvious reason why access would automatically create a 1-2-1 relationship rather than 1-2-Many? I want to change it 1-2-Many. Cant work out how to change the realtionship type Access 2003
Is there an obvious reason why access would automatically create a 1-2-1 relationship rather than 1-2-Many? I want to change it 1-2-Many. Cant work out how to change the realtionship type Access 2003
neileg AWF VIP Local time Today, 08:40 Joined Dec 4, 2002 Messages 5,975 Jun 6, 2008 #2 How have you linked the tables?
D DC27 Registered User. Local time Today, 08:40 Joined Jun 6, 2008 Messages 27 Jun 6, 2008 #3 one field was indexed when it should not have been thanks anyway though!