J Johan Registered User. Local time Today, 05:35 Joined Apr 13, 2001 Messages 12 Apr 26, 2001 #1 In my table I would like some fields to contain more data, Eg. Product ID | Footprint ---------------------------- BC874 | RAD1 | RAD2 ----------------------------- Is that in any way possible
In my table I would like some fields to contain more data, Eg. Product ID | Footprint ---------------------------- BC874 | RAD1 | RAD2 ----------------------------- Is that in any way possible
K KevinM Registered User. Local time Today, 05:35 Joined Jun 15, 2000 Messages 719 Apr 26, 2001 #2 Create two tables and link them by ProductID So... Table1 [ProductID] BC874 Table2 [ProductID], [FootPrint] BC874, RAD1 BC874, RAD2 This is what's known as a 'one-to-many relationship'. HTH
Create two tables and link them by ProductID So... Table1 [ProductID] BC874 Table2 [ProductID], [FootPrint] BC874, RAD1 BC874, RAD2 This is what's known as a 'one-to-many relationship'. HTH