how to update field based on another field?

[atlzbest]

hi guys, sorry if this is under the wrong section.

i've got text fields on a layout linked to table A. i've got a table B that has field names and comments from B.

So whenever a user starts typing in "paragraph" text field, i would like a comments field to get updated from table B.

i know i can put onModify trigger script. what i dont know is how to select and update the comments field. i can get everything in variables but how do i pull up the record and update the field with it?

thanks!

[LaRetta]

We simply need more information. Please explain what the tables represent, how they are related, what you want entered in Table B (I hope it isn't the SAME information as is being entered in Table A's text field). :wink2:

[atlzbest]

hehehe...no

all i need is to update the comments field being displayed based on where the user is typing (doesnt have any relation to table A's contents but rather which field it is)

so if user starts typing in ..say Paragraph (table A field = Paragraph)

comments should update saying you have 10 lines for paragraph. get(activefieldname) is enough to find out its Paragraph.

user starts typing in Bullets, comments textbox should update saying you have 20 lines for bullets.

table B has

textareaname | comments

------------------------

Paragraph 10 lines max.

Bullets 20 lines max.

Table A has

-----------

record_id

paragraph

bullets

filename

there is no join between the tables since there is nothing to relate.

[LaRetta]

I have absolutely no idea how to assist you; I can't understand what you are doing or why. Maybe someone else can. Sorry.

UPDATE: Are you attempting to create an Audit Log which shows all changes per field? If so, do a search here for audit.

Edited July 22, 2009 by Guest
Added update