Append Text

[Anuviel]

Is it possible and if it is how would you do:

Field_A

Field_B

Let's say that Field_A is empty. If anything is entered in Field_B it should display in Field_A without it being deleted when the information is deleted in Field_B.

That is done easily through lookup however if I entered new information into Field_B I would like it to be appended to the information that is already in Field_A.

So basically if I entered 1 into Field_B, Field_A would display 1. If I then deleted 1 from Field_B and entered 2, Field_A would display 12. If then I deleted 2 from Field_B and entered Hello, Field_A would display 12Hello.

Thank you.,

[AudioFreak]

It could be scripted to basically set Field A to itself & Field B.

Script Step would be.

Set Field[Your Table::Field B;Your Table::Field B & Your Table::Field A]

Only prob is it will not update Field B unless the script is run. There are event Plugins that will force a script to AutoRun.

If you don't want to use a plug in, you could set Field A to not allow entry and scipt entering into Field A with a Go To field which will bypass it not being allowed to be entered. Then the end of that script would set Field B when they are done.

Hope that's not too confusing....lol

Edit: See Attached if you get confused.

Michael

Test1.zip

Edited June 22, 2007 by Guest

[Anuviel]

Thanks, the idea works, I always forget about the scripts and try to do everything without using them.

This will work nicely for what I intend to use it,

Thanks a lot.,

[AudioFreak]

Glad I could help ;)

[comment]

I always forget about the scripts and try to do everything without using them.

You could.

Log.fp7.zip

[AudioFreak]

Thanks Comment I like that much better. Yet I use Rays Audit method which I know you know about but maybe Anuviel doesn't.

http://www.nightwing.com.au/FileMaker/demos8/demo809.html

Might as well show him the works.......lol

[Anuviel]

Nicely done, awesome. Tried something similar before posting the question, now I can see what it was that I was doing wrong.

Thank you kindly.,

[Anuviel]

Thanks for the tip about the site., will check it out shortly.

[comment]

Ray's methods are always worth studying.