Lookup Fields

[Sari]

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

[sbg2]

Its hard for us to give an answer without seeing your file, or at least a stripped down example.

[Sari]

I'm attaching some files which might help.

Tbl_Estimate.pdf

Tbl_Quote.pdf

[Sari]

If you need anything else please let me know

tbl_Quote_Line_Items.pdf

Quote_rel_tab.pdf