Hello all,
I have created a table called PersonTable with 3 fields: PersonID (primary key), PersonName and JobName. I have set the JobName field to indexed (duplicates OK) and now I need to enable the user to write, through a Form, attributes for each JobName. These attributes are Industry and AverageSalary and will be stored in the JobTable.
I have attached the document where I tried to do this so that you can see what I have done if necessary. As these attributes will be related to other tables in the database, it would be very useful if I could have a table with each job and its information and also because I would avoid duplicating information. I would really appreciate if you could help me out as I am sure this is not the smartest way to use an indexed field.
Thank you very much!
PS: The information of the PersonTable is imported from another document.
I have created a table called PersonTable with 3 fields: PersonID (primary key), PersonName and JobName. I have set the JobName field to indexed (duplicates OK) and now I need to enable the user to write, through a Form, attributes for each JobName. These attributes are Industry and AverageSalary and will be stored in the JobTable.
I have attached the document where I tried to do this so that you can see what I have done if necessary. As these attributes will be related to other tables in the database, it would be very useful if I could have a table with each job and its information and also because I would avoid duplicating information. I would really appreciate if you could help me out as I am sure this is not the smartest way to use an indexed field.
Thank you very much!
PS: The information of the PersonTable is imported from another document.