Kevin Roach Posted August 16, 2019 Share Posted August 16, 2019 I am putting together a database of All departments in a hospital and our technicians responsible for them. I also need to have 2 backup techs. The database for the techs will be them same techs as the backups. Right now I created tables, fields & relationships for each individual techs and backup techs and that seems like not a very good idea since it is all the same. I need suggestions of how I can pull this of easily especially for doing tech and backup tech updates. I have attached relationship screen and the database file. Thanks, Kevin Biomed Techs Area Responsibilities.fmp12 Link to comment Share on other sites More sharing options...
comment Posted August 16, 2019 Share Posted August 16, 2019 Didn't we discuss this already? https://fmforums.com/topic/104920-technicians-departments-responsibilities/?tab=comments#comment-475077 Link to comment Share on other sites More sharing options...
Kevin Roach Posted August 16, 2019 Author Share Posted August 16, 2019 Yes and no! Same project different question. I have assigned Id's to everything and have it part of it working but had to add more backup techs. Rather then duplicate techs and backup techs I was looking for input on how it should be in a relation. Most Forums get upset when you ask other questions within the original post. Link to comment Share on other sites More sharing options...
comment Posted August 16, 2019 Share Posted August 16, 2019 I think it's the same question. It's all about how to handle a many-to-many relationship. And the answer is the same: you need a table of Departments, one table for the technicians and a join table for the assignments of technicians to departments. Have a look at the attached demo. It shows a textbook implementation of a many-to-many relationship. Note that it is symmetrical: you can assign staff to a department or departments to a staff member, with the end result being the same. Assignments.fmp12 1 Link to comment Share on other sites More sharing options...
Kevin Roach Posted August 20, 2019 Author Share Posted August 20, 2019 I tried the example and great learning experience. I was going about it all wrong. But hey at least I tried! Thanks for the example! Kevin Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1711 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now