Creating new records using other tables

[bullfrog]

I am creating a Dbase and i need to create new records in table A using data from table B & C.

I have been trying 4 ages and uptil now i have been doing it manually and while the company is not using the Dbase i would like to cut my intervension at of the picture.

 

[RV]

You append rows to a table by using queries.
Requirement is that you've got a relation between your tables.

RV

 

[bullfrog]

You append rows to a table by using queries.
Requirement is that you've got a relation between your tables.

RV

What do you mean by that??

And yes i do have realtionships between the tables

 

[RV]

What do you mean by that??

Queries are use to retrieve or maintain data.
If you've never used them before, at least take a look at the Access Help file, have a look at the NorthWind sample database, or try to get more familiar with relational database concept first.

This site could help you on your way:

http://www.functionx.com/access

RV