Update field in one database from another 
Author Message
 Update field in one database from another

I have 2 databases A - Client and B - Time Recording.  Everytime
someone works on a client's project, the date, client No., and time
spent must be recorded in database B.  At the end of the month, I must
find all the active clients who have not had any time recorded, within
a particular period, that belongs to a specific project manager.  

My original thought was to have a date field in each database.
However, the problem is how to update the date in the related Client
database everytime a record is added in Time Recording.  I thought of
using a portal in the Client database with the date from Time
Recording.  However, that doesn't seem to work.

Any ideas?

Thanks in advance for your help.
Don  



Tue, 01 Jul 2003 05:44:44 GMT
 Update field in one database from another

Sure.  Make a script attached to a button that the user clicks whenever
they exit the time recording file and have import the date field for all
the updated records from the time recording file to the client database.
You'll have to make the script (a) in the client  database first and set
your import criteria before you begin writing the script.  Then make a
script (b) in the time recording database that runs the external script
(a) from the client database.  Attach script (b) to the button.  It's as
simple as that.  I have similar things for some of my databases.

Quote:

> I have 2 databases A - Client and B - Time Recording.  Everytime
> someone works on a client's project, the date, client No., and time
> spent must be recorded in database B.  At the end of the month, I must
> find all the active clients who have not had any time recorded, within
> a particular period, that belongs to a specific project manager.

> My original thought was to have a date field in each database.
> However, the problem is how to update the date in the related Client
> database everytime a record is added in Time Recording.  I thought of
> using a portal in the Client database with the date from Time
> Recording.  However, that doesn't seem to work.

> Any ideas?

> Thanks in advance for your help.
> Don

--
Audra Ziegenfuss, BS
University of Pittsburgh Medical School
Department of Cell Biology and Physiology
3500 Terrace Street
SBST 224
Pittsburgh, PA 15261
Phone #:  412-648-9796
Fax #:  412-648-8330


Tue, 01 Jul 2003 06:46:57 GMT
 Update field in one database from another
Hi Don and Audra -

Another method might be to include a calculating field in the databaseA that
shows the date of the most recent related record in databaseB.  You could
use that field in a Find and accomplish your purpose.  The calculation would
be:  Max(relationship::date) expressed as a date.  Hope this suggestion is
helpful.

Best of Luck -
James

Quote:

> Sure.  Make a script attached to a button that the user clicks whenever
> they exit the time recording file and have import the date field for all
> the updated records from the time recording file to the client database.
> You'll have to make the script (a) in the client  database first and set
> your import criteria before you begin writing the script.  Then make a
> script (b) in the time recording database that runs the external script
> (a) from the client database.  Attach script (b) to the button.  It's as
> simple as that.  I have similar things for some of my databases.


> > I have 2 databases A - Client and B - Time Recording.  Everytime
> > someone works on a client's project, the date, client No., and time
> > spent must be recorded in database B.  At the end of the month, I must
> > find all the active clients who have not had any time recorded, within
> > a particular period, that belongs to a specific project manager.

> > My original thought was to have a date field in each database.
> > However, the problem is how to update the date in the related Client
> > database everytime a record is added in Time Recording.  I thought of
> > using a portal in the Client database with the date from Time
> > Recording.  However, that doesn't seem to work.

> > Any ideas?

> > Thanks in advance for your help.
> > Don

> --
> Audra Ziegenfuss, BS
> University of Pittsburgh Medical School
> Department of Cell Biology and Physiology
> 3500 Terrace Street
> SBST 224
> Pittsburgh, PA 15261
> Phone #:  412-648-9796
> Fax #:  412-648-8330

--
Don't forget to remove the obvious spam block when replying.
I advocate making an address book entry and using it!  Thanks!


Wed, 02 Jul 2003 05:57:12 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. update one field in a table from a second database

2. Update field with other fields data minus one day

3. Updating one database from another (one way)

4. ODBC - insert/updating two databases with one insert/update

5. ODBC - insert/updating two databases with one insert/update

6. insert data from one field in one table to another field in another table

7. Copying logical fields to a memo field in one database

8. Script and Copy from one field to another field (Same database, different layout)

9. Update data in one database from another database

10. Trigger in one database to update another database

11. update just one part of the field

12. Updating more than one field


 
Powered by phpBB® Forum Software