AnsweredAssumed Answered

Pulling Data from Table-VLookUp?

Question asked by njudson6 on Nov 18, 2015
Latest reply on Nov 19, 2015 by njudson6

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!

Outcomes