D/Sirs
Thanks to overwhelming guidance from this forum, successfully completed staff table with products table, the required queries and reports.
Now I have one table with staff details called 'staff-tbl' and another table 'job-tbl'.
The jobs are for various emergencies and to designate a staff for same.
For example, the 'job-tbl' will contain say coulmns like 'abandon', 'gas_release', 'fire' and so on. All these emergencies will be assigned to a particular staff based on his rank.
From the guidance I got for my previous staff n products, can I do same by making one more table with staff name-code and job-code.
Or is there a better way of doing this?
brgds/captgnvr
Thanks to overwhelming guidance from this forum, successfully completed staff table with products table, the required queries and reports.
Now I have one table with staff details called 'staff-tbl' and another table 'job-tbl'.
The jobs are for various emergencies and to designate a staff for same.
For example, the 'job-tbl' will contain say coulmns like 'abandon', 'gas_release', 'fire' and so on. All these emergencies will be assigned to a particular staff based on his rank.
From the guidance I got for my previous staff n products, can I do same by making one more table with staff name-code and job-code.
Or is there a better way of doing this?
brgds/captgnvr