You should have a price or rates table and current prices should be looked up from this table. That way you preserve the history of prices charged over time. If you're not concerned with preserving history, and I hope this is not the case, you can simply create a found set and use SetField to change all the prices in the found set.
Thanks for your reply. We don't need a price or rates table, and even if we did we wouldn't have a clue how to set one up. All we need to do is reduce (or increase) our prices across all records. Tracking reductions (or increases) is of no use to us. I'm sure others need to preserve their history but we can't see why we would want to do that.
As for SetField, where is this please? As I say our level is way below even very basic stuff when it comes to using Filemaker. We aren't very skilled by any means. What is like standard for us is quite tricky for us to understand.
So we have an inventory with each record in the inventory showing a field for the price of an item. But we want to reduce (or sometime increase) the whole inventory by a set amount, like reduce everything by 10% or 15% or by £5 or £10. Thus every single item is showing a reduced price, less by 10% or 15% or £5 or £10 or whatever. How?
Never heard of SetField and don't know where to find it. Have looked in the menus but it's not there. If SetFieled is the way to do what we need to do then then that's great, but where, how?
Once again many thanks for your reply.
OK, but beware - this is undoable, so make a backup copy of your file first in case things go wrong..because what you are about to do is a permanent change to a particular field for all records
In Browse mode (that's the normal mode for entering data etc), Select View>View As Table, then all your records should be displayed like a spreadsheet. Click on Show All to be certain that you have all records displayed.
Select the field you want to change, click on Records>Replace Field Contents, you will be presented with a dialog box with three options:
1. Replace with.....[where you can enter a fixed string to update all records]
2. Replace with Serial Number ....[where you can renumber records]
3. Replace with Calculated Result ... [this is what you want]
So Select the last option, then click on Specify, you will be presented with the Specify Calculation Dialog Box, where you can specify a calculation for your field, for example:
nameofyourfield * 0.90 to reduce all the prices by 10% (include bold text only - use your field name), or
nameofyourfield + 5 to increase all prices by 5, or
nameofyourfield *1.1 to increase all prices by 10%...etc
you'll be able to select your field name from the list of fields on the left...
Many businesses use a separate, related table for pricing that includes an effective date. Not only does this preserve previous pricing and the dates for which they applied, but it allows the user to "schedule" a price change by entering a future effective date and the prices that will go into effect on that date.
Amazing. Works perfectly. Like a dream. Simple too. Just wondering why the Filemaker Help thingy doesn't explain it as clearly as you have done. Thanks again.