Simple calc but can not get it to work

[raymate]

Still very new to FM,

I have a simple database that stores multi contacts in a TABed area. And it is set so that when you enter the first contact it also auto fills in the second contact with the same data, so if the user is in the wrong TAB they see the same address, then if they want the second contact different they simple type over the data.

This I have got to work with no problem, auto fill second contact with first contact data, thats simple.

The problem I have is the postal code area I have set to be upper case with a calculation " upper (contact 1 postcode) " and this works on the first contact.

But how do I do this with the second contact.

The second contact i have set as " contact 1 " which take the same data from contact 1, but if the user requires to change the postal code by typing over it, then it does not change to upper case.

I have tried to do " contact 1 & upper (contact 2 postcode) "

But I cant seem to make it work, what calculation would I need to firstly take the data from contact 1, then if they change the data in contact 2 how to mak the change uppper case.

[aldipalo]

You may need to uncheck "Do Not Replace Existing Value" in the field box under Autoenter tab.

HTH

Edited May 10, 2007 by Guest

[raymate]

Thanks for the reply, just tried it checked and un checked and it still leaves text in lower case.

[David Jondreau]

Something along the lines of

Case(contact 1 street address = contact 2 street address; contact 1 postcode;

Upper(contact 2 postcode))

[raymate]

Thanks for the calc, but that dont seem to work at all, it does not feed the data from contact 1 into contact 2

Then if you add data into contact 2 it still stay lowercase.

R

[Dudley Dufort]

Would forematting the field for uppercase do it?

[mr_vodka]

I must admit, I was a little confused about what the exact requirements were for your post when I read it last night. some of it sounded a little contradictory. Can you restate what you are looking for?

To me it seemed as though you have field1 which already has an Upper() auto entry to it. Then field2 is an auto-entry with the value of the data in field1. But you want change the way it displays in field2 if manually entered in field2 ot be upper correct? However, if the value is field one is upper already then field2 should be upper too. So I am confused on what you need.

[raymate]

Sorry about my first post, not very good at describing this.

Yes what you say is correct, apart from the end bit.

field 1 - user enters postcode, with a calc makes it uppercase if uses didnt use uppercase.

field 2 - data from field one is auto entered to make it the same, so yes the data will be upper case as field one takes care of that.

But if the user needs to change field 2 to another postcode and does not use upper case it need to make it upper case with a calc.

So field 1 has just one calc.

And I assume I would need two calcs for field 2

Thanks again in advance for all your help

[raymate]

It would but if I need to print this data in a report I need to make sure the format is forced to upper so I assume just making it upper duting entry is the best way.

Thanks for your reply.