MySql Link tables
Does any one know how to link tables in mysql so when a record is inserted the columns in the tables that are defined as primairy keys all have the same key for a record that was inserted.
So this is what i am doing. we have 3 diffrent departments, Large Doc, Small Doc, and Color. when the user opens up a WO they can select functions that need to be done for the job. There are 4 tables:
WO: keeps track of who the tickett, who is working on it, which customer the tickett is for,etc.
Small, Large, Color: these 3 tables get a data inserted to them from the main form only if there is work to be done in that department, so for example if a job come in and it only goes to Small Doc and Color only the Small and Color get an entry but not the Large table.
So this is what i am doing. we have 3 diffrent departments, Large Doc, Small Doc, and Color. when the user opens up a WO they can select functions that need to be done for the job. There are 4 tables:
WO: keeps track of who the tickett, who is working on it, which customer the tickett is for,etc.
Small, Large, Color: these 3 tables get a data inserted to them from the main form only if there is work to be done in that department, so for example if a job come in and it only goes to Small Doc and Color only the Small and Color get an entry but not the Large table.