Inserting new records from linked table to other Table

[manf01]

Hi All,

I got a problem with new records. Its might be easy but for me its difficult. I will thankful to you if you can help me regarding this problem.

There are 6 tables in a linked database, my task is to create a new table by taking few records from these tables plus self added fields. As I have used make-table query, that’s why new records cannot be inserted automatically. For this I have to run again make-table query. But whenever I run this query it will delete the self added records :-(

I have used Insert query to get new records in my new table. So that It will insert new records in my new table each day(after applying).
I have tried it but I got stuck here.

For example the tables are


MainTable

ProjectName
ProjectId
Description
Accepted
SubmissionDate
HoursWorked

NewTable (by make-Table)


ProjectId (Main Table)
OfferId ( auto Number)
Description (Main Table)
Accepted (Main Table)
OfferDate ( by hand )

 

[manf01]

Sorry, this was my first ever post here. I think it should be in Table forum or in queries Forum not in
forms forum.