I have inherited a project and have been working on the API side of things but am now getting into the table structure and have a question.
Structure:
’Employees’ Table. All employees in the company.
Includes Email, Specialties (Link to Specialties), and Coverages (Link to Coverages).
’Specialties’ Table. All specialties provided by the company.
Includes ‘Name’, and ’ Link to Employees’
’Coverages’ Table. All coverages provided by the company.
Includes ‘Name’, and ‘Link to Employees’
The idea is that I can access the Employees table via the API and get all the specialties and coverages an employee offers. In the linked Specialties column of Employees I can add Specialties just fine and the data finds it way back and forth. Delete an Employee from ‘Link to Employees’ from Specialties and it is great.
The group added this Coverages table and has added all the Employees to the ‘Link to Employees’. They sit there just great. I am now trying to get them to back populate to the Employees table. *
The ‘Link to Coverages’ in the Employee table does not pull back, or push, data to the Coverages table
*.
Why does Specialties working and not Coverages? Is it that Coverages was made after the fact and the employee lookup doesn’t know what to look for. Structurally they look EXACTLY the same.
For the sake of my project being able to make an API call to Employees versus all three would be ideal.
I have to be missing something simple here. Thanks for the support.