I have stressed out about this situation enough and am finally turning to you guys for some help.
I have a database for my print estimating. I have two table "In House Jobs" & "Paper Catalog"
I have a field with a dropdown list on the "In House Jobs" Table that pulls form the "Paper Catalog" Table. When I select a paper, I want it to pull the cost of that paper from the "Paper Catalog" and place it in my Cost Per Sheet field in the "In House Job" Table. Any assistance would be greatly appreciated. I have succeeded in doing this in Excel through Lookup, but FMP doesn't have that function.
Thanks in advance!