Hello all

I have a customer file and an estimate file. I want to write a script to find the last estimate for a customer based on a value within a value list. This is my first time writing a script and I can't see how to set the value for a value list field. The relationship is 1:m in that a customer can have a number of estimates. I'm using FMP v7.3

Many thanks in advance for any help you can give.

eSBee

Hello all

I have a customer file and an estimate file. I want to write a script to find the last estimate for a customer based on a value within a value list. This is my first time writing a script and I can't see how to set the value for a value list field. The relationship is 1:m in that a customer can have a number of estimates. I'm using FMP v7.3

Many thanks in advance for any help you can give.

eSBee

Hello all

I have a customer file and an estimate file. I want to write a script to find the last estimate for a customer based on a value within a value list. This is my first time writing a script and I can't see how to set the value for a value list field. The relationship is 1:m in that a customer can have a number of estimates. I'm using FMP v7.3

Many thanks in advance for any help you can give.

eSBee

Create relation from Customer to estimate. Then use Go To RR script step and last estimate will be in the last record.

Create relation from Customer to estimate. Then use Go To RR script step and last estimate will be in the last record.

Create relation from Customer to estimate. Then use Go To RR script step and last estimate will be in the last record.

Sorry, my explanation was naff. I want to find all customers who has had estimates which have been given a status of "Archived". Due to some customers having more than one estimate, I need to view the last estimate produced. The status field is a popup menu taking its values from the status value list. I hope that better explains it.

Many thanks for your quick response.

Sorry, my explanation was naff. I want to find all customers who has had estimates which have been given a status of "Archived". Due to some customers having more than one estimate, I need to view the last estimate produced. The status field is a popup menu taking its values from the status value list. I hope that better explains it.

Many thanks for your quick response.

Sorry, my explanation was naff. I want to find all customers who has had estimates which have been given a status of "Archived". Due to some customers having more than one estimate, I need to view the last estimate produced. The status field is a popup menu taking its values from the status value list. I hope that better explains it.

Many thanks for your quick response.

Hi,

If Status is an indexed field, then a double equijoin matching Customer and Status involving CustomerID and gStatus (a global for example) on the starting side of your relationship should just reveal all estimates which status match the content of your gStatus field.

Grabbing the first (or last) one is just a matter of how the relationship is sorted as a related field would target the first related record (based on the sort order).

Is that clear ?

Hi,

If Status is an indexed field, then a double equijoin matching Customer and Status involving CustomerID and gStatus (a global for example) on the starting side of your relationship should just reveal all estimates which status match the content of your gStatus field.

Grabbing the first (or last) one is just a matter of how the relationship is sorted as a related field would target the first related record (based on the sort order).

Is that clear ?

Hi,

If Status is an indexed field, then a double equijoin matching Customer and Status involving CustomerID and gStatus (a global for example) on the starting side of your relationship should just reveal all estimates which status match the content of your gStatus field.

Grabbing the first (or last) one is just a matter of how the relationship is sorted as a related field would target the first related record (based on the sort order).

Is that clear ?

I'm not sure that I do. I can create an equijoin from customer to estimate using CustomerID but I don't understand the gStatus field.

Could you please give me an example of what you mean? Like I said, I'm quite new at FileMaker so simple explanations, preferably with examples would be helpful.

Sorry to be a pain.

Many thanks

eSBee

I'm not sure that I do. I can create an equijoin from customer to estimate using CustomerID but I don't understand the gStatus field.

Could you please give me an example of what you mean? Like I said, I'm quite new at FileMaker so simple explanations, preferably with examples would be helpful.

Sorry to be a pain.

Many thanks

eSBee

I'm not sure that I do. I can create an equijoin from customer to estimate using CustomerID but I don't understand the gStatus field.

Could you please give me an example of what you mean? Like I said, I'm quite new at FileMaker so simple explanations, preferably with examples would be helpful.

Sorry to be a pain.

Many thanks

eSBee