Relationship through 2 tables
Hello! Hoping someone can help. I have 3 tables Purchase orders Styles Raw Materials Every Purchase order or PO has multiple styles on it. Every style has many raw materials I wou...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThe setup for the PO Lines is this
One PO has many PO Style numbers (ie the PO Lines)
One Styles Master has Many PO Style numbers (ie the PO Lines)
So you will set up what is sometimes called a "join" table which is a child of both Parents of the PO and the Style Masters tables. The join table will have lookup fields to identify the PO and the Style and will have data entry fields for the Qty, Price, and calculated field for extended price.
That is the easy part.
Then the typical setup for the Raw Materials is this.
One Raw Material Master has many Style Raw Materials.
One Style has Many Style Raw Materials.
ie again, there a many to many Relationships because the "recipe" for one Style will have Many Raw Materials and also a Raw material will get used on Many different Styles.
The middle join table will have lookup field to identify the Style and the Raw Material. Then it will have a data entry field for the qty of the Raw Material required per Unit of Style.
Once you get all that setup, then post back I can try to explain to you how you can get the Raw Materials and their Quantities to show on the PO. Depending on your skill level, it may take an hour of one on one consulting time to get that working as it may be too involved to explain on this Forum.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
One PO has many PO Style numbers (ie the PO Lines)
One Styles Master has Many PO Style numbers (ie the PO Lines)
So you will set up what is sometimes called a "join" table which is a child of both Parents of the PO and the Style Masters tables. The join table will have lookup fields to identify the PO and the Style and will have data entry fields for the Qty, Price, and calculated field for extended price.
That is the easy part.
Then the typical setup for the Raw Materials is this.
One Raw Material Master has many Style Raw Materials.
One Style has Many Style Raw Materials.
ie again, there a many to many Relationships because the "recipe" for one Style will have Many Raw Materials and also a Raw material will get used on Many different Styles.
The middle join table will have lookup field to identify the Style and the Raw Material. Then it will have a data entry field for the qty of the Raw Material required per Unit of Style.
Once you get all that setup, then post back I can try to explain to you how you can get the Raw Materials and their Quantities to show on the PO. Depending on your skill level, it may take an hour of one on one consulting time to get that working as it may be too involved to explain on this Forum.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
