I use that structure all the time where where 2 tables both have one to many relationships with each other, but correct me if I am wrong but I don’t think that is what I am looking for as it creates a many selection in the employeetype table which doesn’t help in an output form. Also thinking ahead to reports where automatic one relationships are much easier to manage.
> On Nov 8, 2017, at 10:20 AM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > [Project] <--[ProjectEmployeeType]--> [Employee] ? > > Keith - CDI > >> On Nov 8, 2017, at 2:06 PM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> Given a Project table and an Employee table where Employees can be Project >> Principles, Project Managers, and Project Supervisors, what would be the >> proper way to create a normalized table structure in 4D. In the end an >> assigned employee’s information, like name for example, would automatically >> be displayed in the project’s output form for each of these assignments. >> >> I am pretty sure using the proper Select/Join commands in SQL this could >> easily be done, but I am falling short with 4D as none of these structures >> work... >> >> [Employees]ID <——— [Projects]PrincipleEmployeeID >> <——— [Projects]ProjectMangeEmplyeerID >> <——— [Projects]SupervisorEmployeeID >> >> OR using linked tables…. >> (There is only one record in each linking table for >> each employee assigned a role) >> [Employees]ID >> <———[Principles]EmployeeID<———-----------[Projects]PrincipleEmployeeID >> <———[ProjectManagers]EmployeeID <——— >> [Projects]ProjectMangeEmplyeerID >> <———[Supervisors]EmployeeID <——— >> -------[Projects]SupervisorEmployeeID >> >> The only way I can see to make it work is to denormalize it and put the >> pertinent data from the Employee table into the linking tables in which case >> the relationship between the employee table and the linking tables become >> irrelevant. >> >> I have no problem denormalizing, but thought this might be a good exercise >> to retain a few more cells in my aging brain. ;-) >> >> John >> >> >> John Baughman >> Kailua, Hawaii >> (808) 262-0328 >> john...@hawaii.rr.com >> >> >> >> >> >> ********************************************************************** >> 4D Internet Users Group (4D iNUG) >> FAQ: http://lists.4d.com/faqnug.html >> Archive: http://lists.4d.com/archives.html >> Options: http://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** John Baughman Kailua, Hawaii (808) 262-0328 john...@hawaii.rr.com ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************