Hi all,

Hope someone might be able to make a suggestion.

I have 2 databases. One is for contacts the other for jobs. Each contact has a unique ID and each job has a serial number. I would like to be able to paste the contact ID into a box on a newly created job on the Jobs database so that the companies name, address, telephone and fax info from the Contacts database moves across automatically to the respective company name, address, telephone and fax empty fields on the jobs database. I can't figure out the relationship between the 2 database and the identical fields in both? Although each job has a unique serial number, a contact can have different jobs on the go. Help!

Probably a newbie question I'm sure!

Edited March 2, 200619 yr by Guest

Hi all,

Hope someone might be able to make a suggestion.

I have 2 databases. One is for contacts the other for jobs. Each contact has a unique ID and each job has a serial number. I would like to be able to paste the contact ID into a box on a newly created job on the Jobs database so that the companies name, address, telephone and fax info from the Contacts database moves across automatically to the respective company name, address, telephone and fax empty fields on the jobs database.

Probably a newbie question I'm sure!

I just answered this on another list. I have reproduced my answer with a few changes here. Hope this helps you

Dave McQueen

.........................................

pseudo script here:

Two files - Parent and Child

ScriptParent1

Freeze Screen

Copy Prime Parent ID

Call Subscript External in Child File/Table (ChildCreateRecord)

ChildCreateRecord

GoTo Layout (With correct fields)

NewRecordRequest

Paste ParentID into Parent_Ident_Field

Refresh Screen in Parent File/Table

Have the other fields in the child file/table lookup fields to pull in data from the parent file/table

You can do this with variations setting a related global field in a prefs file/table and then setting the parent ID field in the Child File from this same global through another relationship - which gets you away from copy and paste operations.

In a network scenario it is important to go right into the child file to create the record and keep that record tied up until the applicable keys are set.

HTH

Dave McQueen

Hi David, Thanks for the reply. Do I need to establish a relationship first between the two database? I'm getting as far as "call subscript External in Child File/Table...." ?

Perhaps you should clarify a few things here:

When you say "2 databases", do you mean 2 tables in the same file, or do you actually have 2 separate files (and if so, why)?

You indicated that one contact can have many jobs. Can a job have more than one contact?