List:General Discussion« Previous MessageNext Message »
From:Graeme B. Davis Date:June 23 1999 7:39pm
Subject:Question about linking multiple rows to a record
View as plain text  
Hello,

Say I have a company table with all of that company's static information.
If say there were something like 1-5 sales reps assigned to this company.  I
don't want to create a static name/phone/etc field for each of the 1-5 reps
in the main db -- how would I link an arbitrary # of reps to a salesrep
table?

Would I use the SET column type?

If someone has an example of how to set this up and how to do a query on
this, that would be great.

Thanks a million

Graeme

Thread
Question about linking multiple rows to a recordGraeme B. Davis23 Jun