rburns77 Posted March 10, 2008 Share Posted March 10, 2008 I have two fields: Expenditure and Price Expenditure = copies made x Price Price = Lookup Looked up value = Equipment ID Equipment ID is a separate FMP file that has two fields: Equipment ID and Price Essentially what I did was create a billing spread sheet. It worked perfectly, until now. I have a equipment ID whose price changed. When I change the price in my spreadsheet, it changes all past months. I want the past months to stay what they were, but change the price for the coming months. Suggestions? Help? thanks! Link to comment Share on other sites More sharing options...
aaa Posted March 11, 2008 Share Posted March 11, 2008 Hi, ruburns77. As i see in your explanation, price is calculated field. Price must be field that lookups value from Equipment ID. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts