I have a layout that has user name and owner names, with a list of identical data for each. I import the needed data from another file by creating a relationship based on the First Middle Last Names. On the paper form, there is a check box to indicate if the user is the same as the owner. I want to be able to check the box, and then have a script or statement that will have the User Firts Name = Owner last Name if the box is checked. Is this possible? I tried the IF statement but it told me I couldn't write it the way I did because it would create a "circular definition". Any ideas out there?

You're just not clear here.

What exactly is the relationship? Are you importing, or just showing a portal? What field are you pulling info from (if "the box" is checked), and where is it going? How is the box checked -- based on a calc or manually?

I guarantee that the confusion you're showing in your post is the reason you're getting the "circular" message. Figure out what info you're using, and how, and you'll probably figure out your own solution.

Sorry for the confusion. What I have is the FN,MI, & LN importing data into the user fields. What I wanted to do was if the owner is the same, and the check box was then checked, that it being checked would automatically fill in the same FN, Mi & LN by having them be equal to the user FN,MI & LN. My calculaton was If(Checkbox=0), UsserFN=OwnerFN,""

Thanks for any help in advance.

Set the calculation as an auto-enter in the User fields.

was If(Checkbox=0), UsserFN=OwnerFN,""

Now I’m a little confused because there is no circular definition here! So, what I would suggest is checking exactly what you’ve entered into your calculation. My bet is a typing error – i.e. you have entered the wrong field somewhere in your calculation. Maybe UsserFN twice instead of OwnerFN? Or, you’ve set this calculation up somewhere else, to work the other way round, i.e. If(Checkbox=0), OwnerFN = UsserFN,""

Also, I don’t understand the “Checkbox=0” part. Is your checkbox field a number or text field? Either way, your calculation won’t work, as the 0, will enter a negative Boolean result (NO) not (YES) when its not checked, resulting in the calculation working the opposite way round, so you need to either use a number with a positive result i.e. 1, or a text result.

I would also try to get to grips with the “Case” statement instead of “If”, you’ll be happy for it in the long run! So your calculation would look like this:

Case(Checkbox= “YES”, UsserFN=OwnerFN,"")