Insert a valule based on a field

[Mike Dunkerley]

Hello, I would like to a automatically insert a value based on a value form a

field. For example if Company name is Ford then customer # = 114. Any suggestions? I have messed around with the

[Razumovsky]

Case(CompanyName = "Ford", 114

CompanyName ="Chevy", 115,

CompanyName ="Yugo", 0)

should work, but if you have more than a few of these, you should consider using a related file that stores company names and their info, related to your main file by companyname::companyname. Could be much more useful for a variety of reasons.

[Ugo DI LUCA]

I agree with razumowsky post. Make a relationship !

[Mike Dunkerley]

THANKS I will try both.