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 record. There may be multiple work records that are associated to the same provider on the provider table. How should I set this one up?
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
------------------------------
I've seen the many to many diagrams but I'm not understanding how that would work in my case.
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.
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.
