I've lurked for awhile and have picked up a lot of great help. But now I'm stuck.
I'm not a developer -- just a small business owner. I've been trying to build a basic personnel database for a year. For awhile I had it, but when problems started creeping in, it became obvious it was time to scrap it and start over.
Here's the deal: The stock personnel database that comes with FMP 13 is great for basic stuff, but I've been trying to customize it with some additional features. Namely, I want to keep track of customer reviews from places like Angie's List and Yelp (which generate more than half of our business). These reviews are valuable and a great way of measuring employee performance. I want to relate these reviews to the employees who helped the customers who wrote them. I also want to add a table for "incidents," mostly the lapses or otherwise negative stuff.
Customers write reviews. Each review is related to two or more employees (they work in crews of 2-4 people). However, sometimes customers write more than one review (some customers have written four or so reviews over the years).
I get how a join table works, for the most part, but I'm not sure what to put into the join table between Employees and Reviews (I can live without a separate customers table, but if I could get this damn thing to work right, it would be nice to have customers linked in.) Do I put the employees in the join table almost as if they're inventory line items?
This is a lot of words for what I'm sure is a simple problem, but I can't get it to work right. Match ID fields seem right, etc. Each review can have multiple employees, and each employee can have multiple reviews.