Jump to content
Sign in to follow this  
raymate

Simple calc but can not get it to work

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

HTH

Edited by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Something along the lines of

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

Upper(contact 2 postcode))

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.