Linking Records Multiple Times from another Table in One Cell (Multiple reference)
Hello, Im am trying to find out how to link one record multiple times. I am attempting to make my material price table and flat-rate table work together.
Right now I have 2 Tables that don’t work together. The First table is a flat-rate table for jobs which includes material, labor hours to have prices for individual jobs such as replacing one fixture. My other Table is just for material and can be updated as prices fluctuate.
Right now with material price changes the flat-rate table has to be updated separate from the material table. So I made a new flat-rate table that links to material so it will update automatically with price changes. My problem is in the quantities, all of my material is based in units of one, on foot of wire, one switch etc. This is how it’s shown on invoices from my supplier so it makes updating prices the most convenient. I can’t link a record multiple times in my flat-rate table to reflect proper quantities of material without changing the original record’s quantity.
Any help would be greatly appreciated. I attached an image of the view showing the basic setup which uses rollup to sum material prices linked from the material table.
