Hi
How can I make table make query run when i click on add new record in my form,or when i exit form?

What type of Query and why?

.

Why is very good question. I realize I can not get what I want in this way,simply because running table make query overwrite exisiting table which means that new created table cannot be in relationship with others,
so lets forget I asked anything in a first place

Thank you for your reply though

You will want to run an Append query and use the "on exit" event of the form

Why is very good question. I realize I can not get what I want in this way,simply because running table make query overwrite exisiting table which means that new created table cannot be in relationship with others,
so lets forget I asked anything in a first place

i dont think this is correct - i think if the new table has the same columns and same name, the realtionships will stay in place

YOU WILL lose any indexes with a new table, so instead of a maketable you could always

1) delete data in existing table (delete * from table)
2) append all the new data (insert into table) - again, it assumes the fields are all named the same

i dont think this is correct - i think if the new table has the same columns and same name, the realtionships will stay in place

YOU WILL lose any indexes with a new table, so instead of a maketable you could always

1) delete data in existing table (delete * from table)
2) append all the new data (insert into table) - again, it assumes the fields are all named the same
Gemma has hit the nail on the head. If you delete the old data and insert the
new data you will keep the relationships and the indexes. definitely the best way to go. As a bonus it is also quicker.