I've got 3 tables: tbl_Quote, tbl_Quote_Line_Items and Estimate. Basically the user enters a breakdown of what they think a job will need in the estimate. They don't necessarily use the figures in the estimate for the quote, it is just a rough guide. However, bought in items entered in the estimate table are used.
I am trying to do a forecast layout based on table estimate but I need the actual quote total (Summary field) which is in tbl_Quote_Line_Items. I seem to be having difficulty getting it to display.
I've tried defining a lookup field in tbl_estimate to get the quote total from tbl_Quote_Line_Items so I can use a summary field to get the information I need but that doesn't work either.
Has anybody got any solutions that don't include a gun to the head?
Thanks