Ok.
just a simple question
i have this huge project set up form i need to knock out before i get
married.
my question is that i have a tons of look up tables, for drop down lists.
most of the content is unique.
so do i need to have an auto number field for the primary key?
wouldn't it be just as fast to stick the actual unique value of the look up
table into the tbl_Mast_Table?
one example:
T_ID Code P_Name
1 AP Airport
2 CJ Criminal Justice
3 ED Education
so no need for the T_ID
second example:
for all the employee data i pull from a pic board app i wrote when i first
started using cf.
usually i just insert the Emp_ID into the master table & reference the
linked tbl_Employee.
that way i can easily grab email, & the usual info that is associated with
that particular employee.
my problem with that is if some one gets canned & they are deleted from the
Pic Board, then
this other app would through up tons of errors, due to the ID's not
matching.
so should i just insert the emp name & relevant info into the master table
to insure stability?
i know this should go to cf_talk, but it seems to simple to go there.
Thank You.
-paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
