Searchin by modifying script trigger field

[Pavel Smirnov]

Have problems with script trigger. There are 2 tables: People and Account, relations between tables are by account name.

In a Account table I had <SearchField>

I need to find records in People table

so name field had script trigger parameter on modify

--------

show all records

enter find mode

set field (People::name; Account::SearchField)

perform find

Script don't work (it's change name field) if SearchField is not Global, but I need to do the each Account record must have own search fields.

Please help, or tell how to make this script more better.

[bcooney]

People and Account should not be related by Account Name, but rather by a meaningless serial ID number.

To Find for People, simply go to a layout based on People and enter find mode, then you can go to related accounts from the People record (perhaps you can show them in a portal).

If you must Find for People on an Account Form, put the related People name field on the Account form. You do not need a global or a script trigger.

Honestly, I'm guessing a lot here. What are you building? Can you describe it a bit and tell us why the user is Finding for People in Accounts?

[Pavel Smirnov]

It's database for human resources department to get a job international workers in russia. it helps to see process of documents each record in this database and automatically fill forms and documents, notifies about ending time and other. Accounts are official workers of company.

So i need instant search of workers, like on iPhone contacts without clicking on a button, but the problem is that 2 or more accounts can use this search at same time.

My decision was: I made Account table make relations with workers table by global field (Workers) that get account name in search script and Name field in account table. So I think each record in Account table can had each entry in fields for searching and I don't understand why relation should not be by account name in my situation?

And script don't works in workers layout "on modify" script trigger,

I had searching field (account::searchField)

set field (workers::GlobalField ; Get (account name) )

show all records

enter find mode

set field (workers::name; account::searchField)

perform find

I'm ready to hear good advices and decisions, thanks.

[comment]

Please explain what you want to accomplish. Describing the things you have tried and didn't work is only confusing.

Note that if you have a Accounts -< People relationship, you can "find" the people related to the current account record very easily by using the Go to Related Record[] script step.

[Pavel Smirnov]

I need to make automatic search when you putting symbols whithout clickin a button. I have 2 accounts in my database. The problem is when two accounts using search in database in workers layout they had their own parameters, thats why I made account table.

<workers>

id_account (global)

Name

<account table>

id

Account name

SearchField

Relation is id_account--account name

Account logining by his password when opens db,

Then workers layot in list view, put symbols in searchfield that wants to find worker name ( here i want to make automatic search without clicking search button ), but second account can search another name, thats why i made account table and relation beetween tables.

1) problem is that script i wrote upper does not work, it changes only field "name" in record workers table

2) problem is that id_account is global and 2 accounts can't have two values in same time

How i can solve this problem?

[Pavel Smirnov]

Maybe my snapshot can help to explain what I need)

[comment]

The problem is when two accounts using search in database in workers layout they had their own parameters, thats why I made account table.

I don't understand this part. IMHO, you should make SearchField a global field (it can be in any table). Any user can modify a global field without affecting other users.

[Pavel Smirnov]

I don't understand this part. IMHO, you should make SearchField a global field (it can be in any table). Any user can modify a global field without affecting other users.

Thank you, it answers my questions:)