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 be thankful to you if i can get any help 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


( At the moment there is no record in NewTable, Secondly adding new records in it with each day new record entry in linked tables )

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 )

 

[PHV]

I have to run again make-table query
I think you have to run Update and/or Append query instead of make-table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[manf01]

Thanks a lot PHV for your reply.

But by creating a table from these queries...... i will not be able to change or add my own data in my new table :-((

Thats why i am using make-table query.

Any Idea about it ?

Thanks

 

[manf01]

I have tried it with Append query, thats working. But when the main database is updated ( the tables which i have used ) then my new created table from Append query must be updated as well.

Can you PHV help me regarding new records ?

Thanks,