Go to filed based on condition

[mleiser]

Here's what I need to do. I have 3 fileds - Field1, Field2, Field3. Field 1 should be filled in first. Field 2 then gets filled in. Field3 depends on the following. If field1 is "x", Field3 should be blank. Otherwise, Field3 should equal to whatever Field 2 is with the option to be changed by the user to something else or blank.

How to do it??

Mike

[comment]

I think it would be best to explain the actual problem. The way I read it now, you are building a user interface that is, how should I put it? Not what I would expect as a user...

[mleiser]

• OK. We have a daycamp. Various possible trips. Whole summer, first four weeks, second four weeks, first 6 weeks, last 6 weeks. We enter family info followed by a portal with the campers. Each camper is entered. Then the trip he/she is attending, then the bunk they will be in in July and the bunk they will be in in August. Most campers are in the same bunk the whole time they are there but they could be changed. So.... The July bunk is entered for any trip except if only the last four weeks. The August bunk for all trips except the first four weeks. So.... If the camper is only coming first four weeks, we want to enter July bunk only and keep August bunk blank. If only August, we want to keep July bunk blank and August bunk filled in. In all other cases, we want to fill in July bunk, then have August bunk fill in automatically with the same bunk as July with the option for us to change it.
  
• Whew!! I hope it makes some sense. So it's all dependent on the trip (Field1 above).
  
• Mike
  

[comment]

OK, then. I think you want the AugustBunk field to auto-enter the following auto-enter calculation (replacing existing value):

Case (

not IsEmpty ( Self ) ; Self ;

TripType ≠ "first four weeks" ; JulyBunk

)

[mleiser]

Thanks