Jump to content

Find records in 2nd DB


This topic is 5641 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

This topic is 5641 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.