K kadams0920 Registered User. Local time Today, 08:32 Joined Mar 14, 2007 Messages 20 Aug 9, 2011 #1 How do you create a multiple valued data type in Access 2007 that can be used in Sharepoint?
L llkhoutx Registered User. Local time Today, 07:32 Joined Feb 26, 2001 Messages 4,018 Aug 11, 2011 #2 Create atable of the linked value with a foreign key to the root table, i.e. Parent Table PKParent etc Children Table PKChild FKParent Value PKParent (parent key) = FKParent (parent key in child) e.g. PKParent = 1 PKChild =1 FKParent = 1 Value = 123 PKChild =2 FKParent = 1 Value =4456 PKChild = 3 FKParent = 1 Value = 444
Create atable of the linked value with a foreign key to the root table, i.e. Parent Table PKParent etc Children Table PKChild FKParent Value PKParent (parent key) = FKParent (parent key in child) e.g. PKParent = 1 PKChild =1 FKParent = 1 Value = 123 PKChild =2 FKParent = 1 Value =4456 PKChild = 3 FKParent = 1 Value = 444
