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.

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.

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.

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.

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.

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, 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.

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.

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.