Need linked table to autoupdate based on form

[et10yl]

Hi,

I have a spiffed up version of Access Database Wizard's Time & Billing database. The other database is the Wizard's Ledger database. I'd like to synchronize both databases such that any entry into the Time & Billing database as a payment is also automatically put into the Ledger database as either a withdrawal or deposit.

E.g. A client makes a payment to me, I input it in the Time & Billing database as a client payment, and it automatically shows up in the Ledger database as a credit on one of my accounts. When I make a payment, it is input in the Time & Billing database as a payment to others, and also shows up in the Ledger database as a debit on a certain account.

Is this possible? Is this even the right forum to be posting in?

Thanks VERY much!
noush

 

[JeremyNYC]

Right forum, sure.

Possible? Definitely.

Recommended? Probably not. I would suggest putting all of the tables in one database. It will make administering the database much easier. There are times when it makes sense to have the tables split between multiple databases, but this situation doesn't seem to require such a complex set up.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[et10yl]

Thanks for answering Jeremy.

You are right in that it probably would be easier (and neater) to have all the tables in one database.

Still, could someone point me in a direction as to how I can have the updating done? I'm a total beginner when it comes to code, so I'd appreciate any help I can get.

Thanks much!