script many to one

[fmp7_user_fmp7fmp7]

I have a shipping file that has a record for each customer purchase as follows:

Record 1

Name: joe Smith

Address: 45 J st

Item purchased: widget 34

Weight 5oz

Record 2

Name: joe Smith

Address: 45 J st

Item purchased: widget 57

Weight 10oz

reimbursement

Record 3

Name: joe Smith

Address: 45 J st

Item purchased: widget 16

Weight 5oz

How can I determine the total weight for this customer when all three of the widgets are in separate records?

I think a self join relationship would work somehow, or creating a new record with globals for the weights?? Attached is my work on the script to find the duplicate names I am close but I have hit a wall. Any help would be appreciated. Thank you.

[fmp7_user_fmp7fmp7]

I have a shipping file that has a record for each customer purchase as follows:

Record 1

Name: joe Smith

Address: 45 J st

Item purchased: widget 34

Weight 5oz

Record 2

Name: joe Smith

Address: 45 J st

Item purchased: widget 57

Weight 10oz

reimbursement

Record 3

Name: joe Smith

Address: 45 J st

Item purchased: widget 16

Weight 5oz

How can I determine the total weight for this customer when all three of the widgets are in separate records?

I think a self join relationship would work somehow, or creating a new record with globals for the weights?? Attached is my work on the script to find the duplicate names I am close but I have hit a wall. Any help would be appreciated. Thank you.

[fmp7_user_fmp7fmp7]

I have a shipping file that has a record for each customer purchase as follows:

Record 1

Name: joe Smith

Address: 45 J st

Item purchased: widget 34

Weight 5oz

Record 2

Name: joe Smith

Address: 45 J st

Item purchased: widget 57

Weight 10oz

reimbursement

Record 3

Name: joe Smith

Address: 45 J st

Item purchased: widget 16

Weight 5oz

How can I determine the total weight for this customer when all three of the widgets are in separate records?

I think a self join relationship would work somehow, or creating a new record with globals for the weights?? Attached is my work on the script to find the duplicate names I am close but I have hit a wall. Any help would be appreciated. Thank you.

[mr_vodka]

If you are using FM6, create two files. One for customers and the other for item purchased, weight, etc. The relationship should be based on a customerID number. Then it becomes easy. All you have to do is create a calc field that sums up the weight through the Customer to Purchases relationship.

[mr_vodka]

If you are using FM6, create two files. One for customers and the other for item purchased, weight, etc. The relationship should be based on a customerID number. Then it becomes easy. All you have to do is create a calc field that sums up the weight through the Customer to Purchases relationship.

[mr_vodka]

If you are using FM6, create two files. One for customers and the other for item purchased, weight, etc. The relationship should be based on a customerID number. Then it becomes easy. All you have to do is create a calc field that sums up the weight through the Customer to Purchases relationship.

[Vaughan]

Mr Vodka, I'm sorry to report that the post that you spent your valuable time to tink about and respond to is, in fact, a duplicate post. A post that I responded to with almost exactly the same answer.

The person using the name "fmp6_user_fmp6" should seriously consider apologising for wasting our valuable time.

[Vaughan]

Mr Vodka, I'm sorry to report that the post that you spent your valuable time to tink about and respond to is, in fact, a duplicate post. A post that I responded to with almost exactly the same answer.

The person using the name "fmp6_user_fmp6" should seriously consider apologising for wasting our valuable time.

[Vaughan]

Mr Vodka, I'm sorry to report that the post that you spent your valuable time to tink about and respond to is, in fact, a duplicate post. A post that I responded to with almost exactly the same answer.

The person using the name "fmp6_user_fmp6" should seriously consider apologising for wasting our valuable time.