I'm not sure if this is the best place to log, but . . .

I'm sure this should be easy, but I cannot figure this out. I have limited understanding of tables and so have created two different DB's.

1. Jobs (each job/record has a unique Job number [example - 06-0054])

2. Expenses (some, but not all, expenses are related to jobs) For expenses that are related to specific jobs the corresponding job number is entered [06-0054] (but not linked to Jobs DB).

What I want to accomplish:

Users may enter job records and wish to see related expenses. I would like to write a script so that:

job number of current record is copied

Expenses DB is opened and enter Find mode

Go to Job # field in Expenses DB

Paste Job # copied from Jobs DB

Find (this would find only expenses with Job # equal to 06-0054)

My problem is that if I write script in Jobs DB, though I enter Expenses DB, Find step relates to Jobs DB.

I'm sure this is an awkward way to accomplish what I want, but . .

Edited April 14, 200619 yr by Guest

You should'nt be doing a find for this, the related records should be shown in a portal. example attached.

MyDB.zip