[thelist] Q on databases

Tab Alleman Tab.Alleman at MetroGuide.com
Fri Mar 12 09:30:42 CST 2004


Jonathan Cone wrote:
> My first thought on this is to creat a contact method table, a list
> 	table with the types of contact methods.  Have a field in your
job
> table that holds the foreign key of the contact method. 

I would agree with the Contact_Method table, except I would then also
add a linking table to connect jobs to contact methods, so that jobs can
have more than one contact method, which I assume is probably the case. 


More information about the thelist mailing list