Need guide please.

[MaMister]

Hi,

I have created a simple database named: tblcustomer.mdb with fields of Company, Address and Tel

I would like to create another database which records the jobs that I have done for these companies. I name it tbljobrecord.mdb with fields of Company, job 1 and job 2

My question is, how can I link the Company field (tblcustomer) with the Company field of (tbljobrecord) so that everytime I add in a new Company (tblcustomer), it will be updated on the tbljobrecord too.

Thanks.

 

[ColinEssex]

No need for a second database, create another table for the jobs and link in the relationships. The tables will be linked by the IDNo (an autonumber)

Col

 

[MaMister]

Thanks for the help.

I manage to try out and link the 2 tables and it works.

But when I try to create form, the link didn't show up as it is in datasheet view.

Any idea?

Shapshots: http://techland.com.sg/Example.html

 

[ColinEssex]

Always use a query as the forms recordset, not the table. Then you can bring in fields from several tables if needed

Col