I asked a question earlier about how to handle lookup tables, I think this is a little more clear as to what I was trying to ask.
if I want to relate a contact to an organization, I know I can create a table that contains contact_ids and org_ids. But, how do I enter that information gracefully, i.e. from a webpage? Assuming someone has already entered a persons contact info, and I have info for several organizations how would I go about assigning a contact to that organization? It isn't feasible for someone to remember all of the ids for each business and each contact. I could create a webpage that is used to assign contacts. Would I want to query each table and present two pull down boxes one with contact names and one with organization names, and they would make thier selection and hit enter... In the background i.e. perl or php, once they hit submit I would then enter the org_id and contact_id for each selection into the relation table? IF this is correct, can someone share some code examples (perl preferably) on how this could be accomplished? Thanks, Taylor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
