I am a professional resume writer. Up until now, I’ve kept a really (really) big Excel spreadsheet filled with keywords for 100+ professions and job titles. Here’s my dilemma - since job titles sometimes vary for the essentially the same role, is there a base where I can upload everything in a more searchable way? Does anyone have ideas?
The first table Job Titles has one job title per row.
The second table Keywords has one keyword per row.
After you create both tables, create the link between them.
In the Job Titles table, create a new field.
Under Field Type, select Link to a record.
Under Link to Table, select the Job Titles table.
Under Relationship, allow linking to multiple records.
You can then copy paste information from your spreadsheet into the tabes (assuming that the spreadsheet has columns set up the same way).