Auto Enter

[Chetgeo]

What Im trying to do is, field A ( choose service ) and when a choice is made, auto enter a value into field B from field C. Field A is a list of hundreds of services, field C is the person whom is to get credit ,but multiple people can get credit on this form. Field B is who gets the credit for the charge. This way the person adding services only has to make a change once in field C instead of having to do it for every charge on Field B. Have I been able to confuse u?? I am pretty sure that i could write a script to do the checking and pasting, but i want it on the fly.

Thanks for any and all help

[LiveOak]

You can probably do a calculation to accomplish this, but you'll need to provide us with more information before it can be determined what the calculation is. This type of thing is usually done by using two fields for B.

Field B Calculated

Field B Entered

Field B Calculated (calculation) =

If(not Is Empty(Field B Entered), Field B Entered, Field C)

Set Field B Calculated to not allow entry (you can't really change it, but this prevents clicking into the field). Make Field B Calculated opaque and stack it on top of Field B Entered.

What happens is that Field B Calculated is always displayed. When you click on the Field B stack, you click to the bottom field (Field B Entered), so it looks like you have one field and are clicking into it.

This can also be don't by using auto enter, but how to make it re-evaluate after one field is changed is a little more involved.

-bd

[Chetgeo]

What kind of info would you like, and I tried the If(not Is Empty(Field B Entered), Field B Entered, Field C) and it told me that it was looking for a "(" where "Is Empty" is.

[andygaunt]

Hi,

Take out the space between Is Empty:

If(not IsEmpty(Field B Entered), Field B Entered, Field C)

[Chetgeo]

Ok, i removed the space and it works (that part)

I did what you described but overlapping the fields because i dont think i need the field B entered, because if i just put field B calculated where the dr. code goes, I will not need them to put anything in field B entered.

___ (dr. code goes here) ____________________(services provided here) ______(charge appears here)

What i want to do is to have another field somewhere else where they can put in there Dr. code and for every service provided for there shift will automatically appear. And when the next doc does a charge they change that one field and then for every service they provide it puts there dr. code in that appropriate box.

And thats for the help there Andy. I have yet to have much experiance w/the If(not IsEmpty command.