Calculation Problem

[kshelton]

At least I think it is a calculation problem. All following figures are approx.

File of 200 records. A record is a job sheet which is active for up to 3 days. It is then retained to provide ongoing analysis, i.e. records are never deleted. Five new records are created each weekday.

Fields relevant to my problem are:

1 Service (Supplier). This contains a value list of 10 Services (unlikely to increase above 20) in the form of 01 ABC, 02 XYZ, etc.

2 Value. This contains a value list of 5 numbers (unlikely to increase above 20) in the form of 0.50, 1.00, etc. Each Service is allocated a particular value which is reviewed at week end and which may be changed for each new week. Services may or may not have the same Value as one another.

Objective:

The Value is important and time is critical when a new record is created. Therefore I would like to be able to set the new Value for each Service at the end of the week and then, when a new record is created and the Service selected, the correct Value is entered automatically.

I have tried adding a 'New Value' Global field for each Service and changing the Value field to a calc which picks up the Service and the relevant figure from the New Value field. This works except that it alters existing records.

Any suggestions are appreciated - hopefully there is a simple solution.

Keith

[comment]

At least I think it is a calculation problem.

Doesn't seem so. If you want enter a default value and keep it, use a lookup or auto-entered calculation. Also, keep in mind that global fields do not retain changes from session to session when a file is served.

A convenient solution would be to have a table od Services, where each service is allocated a default value. Then, when you select a service, the corresponding default value can be looked up from the matching related record.

[kshelton]

Just to say thanks. That's worked fine. I already have a Contacts file, so I have related to that.

Just shows how rusty I am as I did similar things years ago with Quotations etc. in FM4.

Thanks again.