Hello everyone

I have spent a few days familiarising myself with 7 and I have been disciplined enough in that I have not just dived in there but have done a lot of reading about and peeking at 7.

It looked really good and the more I read the more confident I became that I was doing the right thing - until I tried to do something productive with it

Today I thought I better try one or two things out and blow me something that would have taken me 5 mins in 5 has taken all day and I still havn't achieved anything.

I was trying to get used to the idea of context so I set up 2 tables Customer and Contact

Customer has fields CustomerName and CustomerNo

Contact has CustomerName, ContactName and CustomerNo

I imported the customer file from my converted 5 file - very nice, very quick

I Imported the contacts file from my converted 5 file - same

I defined a relationship between the two based on customerName

I then wanted to run a script that would step through the contact file, go to the related record in the customer file and set the CustomerNo in the contacts file to the CustomerNo of the related record in the Customer file.

I have spent all day trying all kinds of steps. I can get it to work on one record but not in a loop.

Easy in 5.

Can someone tell me the script steps I should take in 7

TIA

Phustrated Phil

Why are you going to the related record?

I think all you need is SetField [Contact::CustomerNo; Customer::CustomerNo].

Wrap this in a loop starting at first record of Contact and ending at the last.

Ralph

Thanks for the quick reply.

I am sure you are right. I just got wrapped up in things that I shouldn'ta oughta. Seeing the woods for the trees and all that.

Also while setting up relationships I have just found that I had changed my relationship to an AND relationship (Cname and Cno) instead of two seperate relationships

Thank you for helping to clear my mind

Phil