Re: The correct way to deal with name_1, name_2, name_3

2003-11-17 Thread Stephen Fromm
- Original Message - From: Paul Fine [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 17, 2003 10:37 AM Subject: The correct way to deal with name_1, name_2, name_3 Greetings, I would be greatful for any advice on the correct way to do this. If I have something

RE: The correct way to deal with name_1, name_2, name_3

2003-11-17 Thread Paul Fine
Thanks. I do mean Do you mean one column for each name, in which case these would comprise 10 columns, most of which would have NULL most of the time? Is this your suggestion in this case: Table 1 | blahblah | blah | blah | CustID (PK) | Table 2 | CustID (FK) | Name | Table 2 Sample Data |

Re: The correct way to deal with name_1, name_2, name_3

2003-11-17 Thread Stephen Fromm
- Original Message - From: Paul Fine [EMAIL PROTECTED] To: 'Stephen Fromm' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, November 17, 2003 11:49 AM Subject: RE: The correct way to deal with name_1, name_2, name_3 Thanks. I do mean Do you mean one column for each name, in which