add new records to another database?

[kathnicole]

Hi All,

I have a database called "Quote" and another database called "XJob", "YJOB" and "ZJOB".

In QUOTE database, i have two tables "CustomerIn fo" and "Quote"

In XJOB database, i have similar tables "Customer" and "XJob"

In YJOB database, i have similar tables "Customer" and "YJob"

In ZJOB database, i have similar tables "Customer" and "ZJob"

I dont wanted to create all these tables into one single database as the


I would like to know how can i add new records to JOB database from QUOTE database???

the reason i wanted to acheive this is because, QUOTE database prepares a quote for the Customer and once it is confirmed, i want a button for the user to click so that it adds the confirmed quote as the new job in the the respective JOB database.

Could anyone assist me in this regard?

thanks

Kathy

[cyberdwarf]

Hi Kath

Are we talking about an Access mdb, or about SQL data?

Steve

[kathnicole]

Hi Kath

Are we talking about an Access mdb, or about SQL data?

Steve

Sorry for not mentioning this...

this is about Access mdb...

The Quote Database is in Ms Access 2007 and other mdb's are in 2003 format

chuz

[kathnicole]

Sorry for not mentioning this...

this is about Access mdb...

The Quote Database is in Ms Access 2007 and other mdb's are in 2003 format

chuz

Hi,

Am still waiting for a response from someone.

chuz,
Kathy