Hi

I have a calculation for a Cost field I need to do... I need to make sure only the relevant fields are used from other tables, so i need something like this:

sum ( Equipment::RatePerDay ) where EquipmentRental::EquipmentID = Equipment::EquipmentID ....

the problem is in the WHERE ... whats the keyword in FM for this???

Thanks

Costs change with time, therefore you don't want to use relationships to get cost. Use a lookup, the value does not chaneg unless a re-lookup is performed. The lookup is based on a relationship. The cost is no longer a calculation but a number field. The extended cost = cost * time.

Hi Adam, FM does not actually use WHERE statements like SQL does. When you initially set up the relationship, you are effectively creating the WHERE portion of a SQL statement. Thus, if you have a relationship between Equpiment and EquipmentRental based on EquipmentID, then you could just use

Sum ( Equipment::RatePerDay )

to get the result (i think) you're looking for.

Does this help?

Jerry