Hi all.

I have a question relating to finding with scripts.

I have a file with 2 tables, Table 1 and Table 2. Both tables have corresponsding fields with linked data. Here is what I would like to do.

I would like to create a button in Table 1, that will copy all data from a field named "Code" in table 1 and then switch to table 2, perform a "find" and insert the data copied from "Code" in table 1.

Please can someone guide me on exactly how this would be done step by step.

Thanks

Both tables have corresponsding fields with linked data

Does this mean that the two tables are related? Do you have keys in each table that will allow the records to be related?

If so, you can just use

Go to Related Record, set field [Table2::field; Table1::code] and then commit record.

Hi John.

OK, in Table 1, there is the "Code" field. Table 2 is essentially a contact tracking table so the idea is that all a supervisor would have to do is go to a client in table 1, and click a button to be taken to table 2 which has all the contacts made to that client.

Forgive my ignorance, but I donot understand your instruction. I am still very new to this.

I will continue to fiddle and if I figure it out myself, I will post, otherwise I will await a response on exactly how to do it.

Thanks again.

Yaniv--

Let's assume the following structure:

Table People:

PeopleID (Unique AutoEnter Serial number)

etc.

Table Contacts:

ContactID (Unique AutoEnter Serial number)

PeopleID

etc.

A relationship between the two tables on the PeopleID will make it so that you can display only those Contact records that match the current Person (as defined by the PersonID of the record currently being viewed).

You can either script this display by creating a script that has the step described by John, or you can add a portal to your layout that displays the Contact info on multiple lines on the display. I personally like this approach, as it gives you immediate basic information, and you can set it up so that the user can view fuller information if they need it. You can even have it so that users can add new contact records right from the portal...

HTH,

David

Hi all.

Thanks for your help... focused me in the right direction even thos I did not quite understand where you wanted me to go to complete this command. Here is what I did. I am sure there was an easier way to do it.

____________________________________

Go to Field [Dealers::Dealer Code]

Copy [select; Dealers::Dealer Code]

Go to Layout ["Contact Tracking"(Contact Tracking)]

Enter Find Mode []

Paste [select; Contact Tracking::Dealer Code]

Perform Find []

____________________________________

Thanks again.