Automate input fields

[Robtech]

I am new at scripting and would like to create a script that creates a new record and fills in the fields based on field content from other databases. Any ideas?

[LiveOak]

Yes, but we'll need more specifices about the other databases. The general answer is it's done with relationships and scripting. This is kind of like asking a contractor if he has any ideas about how to build a kitchen! . Here is the "it has a stove and sink" answer.

New Record/Request/Page

Set Field()

Set Field()

Set Field()

-bd

[Robtech]

what i am doing is trying to create a log record of the users actions and would like to place certain info from fields of one database to corresponding fields in my log database. Let me know if you need more. Thank you.

[LiveOak]

How about the names of the files, the names of the fields you would like to bring across, What a record is in each file (a person, an action, etc.), and how the files are related.

As a general rule, you don't need to duplicate data in two files. If one file is a file of users and the other of actions, there should be no need to store data from one file in the other.

-bd