"Business Manager
Business Manager",
"CFO",
"IT Tech",
"Network Adminstrator",
"Sales Rep",
"Sevice Manager",
"Super",

What about when record is updated, How to update the building_id in the upper panel.  It is populated by the buildings table. Create a delete and insert statement for the contact_types_sp table to remove the orig building_id and insert the new building_id for this contact_id. Will need to query conta 

Hi Bob

Since the building_id and building_name are gone from tblContacts.  Should I 


A user in tblContacts can ONLY have 1 Job Title, but they can select multiple values in the contacts list window. If I select the jt_name from Job_Titles_tbl for the job position dropdown

INSERT INTO contact_types_sp (contact_id, contact_type_name [jt_id from the Job_Titles_tbl], building_id, primary_location) VALUES($cont_id, $jt_id, $bldg_id, $pri_loc);

for now use

INSERT INTO contact_types_sp (contact_id, contact_type_name [jt_id from the Job_Titles_tbl], building_id, primary_location) VALUES($cont_id, 1, $bldg_id, $pri_loc);







/*SELECT * FROM contact_types_sp WHERE contact_id = 2180*/

/*SELECT cts.contact_id contact_id, cts.building_id buildId, cts.primary_location pri_loc, bldg.building_name bldg_name, tbc.`Job Title` job_title
                                        FROM contact_types_sp cts
                                        INNER JOIN tblContacts tbc ON tbc.`ID` = cts.contact_id
                                        LEFT JOIN buildings bldg ON bldg.id = cts.building_id
                                        WHERE cts.contact_id = 2180*/

SELECT tbc.`Job Title`, jt.jt_name, jt.jt_id, tbc.`ID`
FROM tblContacts tbc
INNER JOIN contact_types_sp cts ON cts.contact_id = tbc.`ID`
INNER JOIN `Job_Titles_tbl` jt ON jt.jt_id = cts.contact_type_name


/*SELECT jt.*, cts.contact_type_name FROM Job_Titles_tbl jt
INNER JOIN contact_types_sp cts ON cts.contact_type_name = jt.jt_id*/

/*SELECT cts.contact_id contact_id, cts.building_id buildId, cts.primary_location pri_loc, bldg.building_name bldg_name, tbc.`Job Title` job_title
                                        FROM contact_types_sp cts
                                        INNER JOIN tblContacts tbc ON tbc.`ID` = cts.contact_id
                                        LEFT JOIN buildings bldg ON bldg.id = cts.building_id*/