Many to Many relationship I think
I have two tables. One is a work record table and the other is a provider table. I want to create a work record and pick the providers on the provider table that are associated with that work recor...
Forum Discussion
Hi, my sugestion for many to may is use a 3 tables.Look the diagram whit my proposal for best thinks and ideas.
------------------------------
Marcelo Benavides
------------------------------
------------------------------
Marcelo Benavides
------------------------------
I've seen the many to many diagrams but I'm not understanding how that would work in my case.
------------------------------
Carol Mcconnell
------------------------------My work records will be created daily and each time a work record is created, I need to pick which provider record is associated to that work record.
------------------------------
Carol Mcconnell
------------------------------Does each work record have more than one provider associated to it? If it it just one provider specific to that work record then you can get away with making Providers the Parent in a relationship to Work Records.
If there are multiple providers - then the intermediary table is needed - and the best setup is to make the relationship and then put an embedded grid-edit report of your work-providers on your Work Form so that users can grid edit/select which providers are needed that way.
------------------------------
Chayce Duncan
------------------------------Each work record could have 1 or many providers and each provider could be connected to more than one work record.
------------------------------
Carol Mcconnell
------------------------------
