Help Needed

[viralmand]

Hi!
I am new to MS Access and this is my very first post in this forum.
I want to create a database using MS ACCESS 2007, i am having one tabel which is having the details of the custmers, like Customner Name, Address. City, the Second Table is having Transporter Name, Now i want to create a data base or you can call the third table which contains Custmer Name, Address & City from 1st table, Transporter Name from 2nd Table and some new fileds like Invoice No, Invoice Date, Amount.
I want to make the data base such that as I select the Custmer Name from the Combo Box, Its Address, City will Automatically fills in the 3rd Table and I had to Add the Invoice No. and Date of the Invoice and In the report and this all field are saved in the 3rd table.

-

 

[ColinEssex]

Firstly, you may like to consider using a more meaningful title for your post. "Help Needed" is not very good and many people here will not bother to read your post.

Secondly, tell us what you have done so far.

Col

 

[georgedwilkinson]

Colin is right.

And you don't want to copy fields already in one (or more) table(s) into a 3rd table, just the reference to those tables (preferably as an auto-number primary key/foreign key pair).

Why not just look at the Northwind database that comes with Access? It probably already does what you need done.

 

[Rabbie]

Read this to see how to pose your question sensibly