Flag This Record

[Frink1234]

I've been working on this a couple of days and keep stumbling. If one of you would like to jump in and give me a boost it will certainly be appreciated.

I want the checkbox in layout "Notes" to make the text of the displayed record to appear in the text box of the selected client in layout "Flag_This_Record". Obviously, only one note at a time can be "flagged" for any one client.

Thanks.

Flag_This_Record.zip

[Brian C]

I'm not sure what you are asking for specifically, but since you seem to be referring to a checkbox causing something to show in another field, I will take a stab at that part of the question.

Field: CheckBox01 (options: Y, N)

Field: TextToDisplay

Field: cDisplayCheckBox = [ If( CheckBox01 = "Y" , TextToDisplay , "") ]

To add multiple fields to the result just concatinate them with &.

i.e. TextToDisplay01 & " " & TextToDisplay02 & " " & TextToDisplay03

[Frink1234]

Sorry, I should have said I attached a file as an example of what I am testing (it's attached to my original post.) To be specific:

Layout#1 has:

Client_ID Field

Client Name Fields

Text Box

Layout #2

Client_ID Field

Note_ID Field

Text Field

Check box

In Layout #2 I want to be able to have several notes on a particular client and whichever one I "flag" with the checkbox, that note will appear in the

Text box field in layout#1.

I added another table to my example because I thought it may need one to hold some temporary info in global fields.

[comment]

I have only recently posted a demo that you can adapt here .

[Frink1234]

OK thanks, I'll take a look at it.

[Frink1234]

Sorry to re-visit this thread, but I'm still having problems, and I've tried modifying Comments previous post but still get nada. Once again:

Layout#1 has:

Client_ID Field

Client Name Fields

Text Box

Layout #2

Client_ID Field

Note_ID Field

Text Field

Check box

I'm using a calculation field to set the Text Box to the Text Field if check box = "yes"

This works fine for only the first note of each record but not subsequent notes. (see attached file to this post)

Flag_This_Record_2.zip

[comment]

You haven't examined the demo carefully enough. See if the attached helps.

Flag_This_Record_2.fp7.zip

[Søren Dyhr]

Brian you're giving yourself too much typing work:

Field: cDisplayCheckBox = [ If( CheckBox01 = "Y" , TextToDisplay , "") ]

It's much simpler to write: If(CheckBox01;TextToDisplay) ...in my humble opinion

--sd

[Frink1234]

Wow, you were right about having to examine your example carefully. It took me a while to find the "format number as boolean" option to get the "Yes, No" to display (I'd never used that before). I am also still having trouble with using TO's but you're example(s) really help me. Thanks again. I really enjoy this learning process, although I sometimes get impatient.