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
------------------------------
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
------------------------------You'll need the many-to-many / intermediary table then to Marcelo's diagram. Set up a table called 'Work Providers' of if there is another name that makes sense.
That table will be related to Work Records where Work is the parent to Work Providers, and then another relationship to Providers with Providers also as the parent to work providers.
On your work record then - you will have the Report link field that Quickbase creates - it should be called 'Work Provider Records' or something like that. Put that on your Work Record form - and change the settings to display it as a report that shows you a field like "Provider Name". If you make that report link editable so that users can grid edit from the form - they can easily view the Work Record and then enter multiple Providers associated to that work record in a grid edit format.
------------------------------
Chayce Duncan
------------------------------
