Hi all

I have not been able to figure this one out. I have two db and i am trying to automatic enter a date into the second db. The first db has a form for welders qualification. A welder may be qualify for two different processes on the same form at the same time. So the date for both of the processes would be the same. The second db has a list of the processes and a field to install the date that each process was qualify. I can do this manual but was looking for a way to do is automatic. Also went the same welder is requalified on one or more of the processes, I would like for the date to change to that date in the second db.

The best way to explain would be to give an example so here goes.

First db

Processes

GMAW - Manual I would like to enter date here

GMAW - Semi-Auto

FCAW - Semi-Auto

FCAW - Machine and here.

Second db

GMAW - Manual Date

FCAW - Machine Same Date (IF rqualified for the FCAW, The requalifying date)

There is only one date field in the welders form. The two db are link together by a "Set Field" script that creates record went a new welders is added. The db's are related by the welders id number

thanks for all the help in the past. I hope I have explain this well enough.

oilman

Hi,

If I understand it right you have a field on db1 with date. Today or some other?

In your script in db1 you make a SET field.

SET(db2:Date ; Date from db1)

gOOD LUCK.

-Per