Hi there-
What’s the best way to do this… We want a grid that shows a list of people, and all the jobs they can possibly do.
But, because one person can do hundreds of jobs (ex: general contractor), we want to display it well. Ex: show the first 2 jobs they can do, and then if they click something, it shows more. NOTE we also want the list searchable by job.
How can this be done? Table details below…
We have a table of people:
pid (autoincrement primary key)
Name
Email
Then a table of jobs they can do:
job_id (autoincrement primary key)
Title
Then, a “link” table, people_jobs:
pid
job_id
NOTE: Some people can do 1000 jobs! Example: Job can be woodwork, painting, framing. And someone who’s a general contractor can support thousands of these jobs.