delete queries, a possibility?

[Callum]

Hi all, never made one, never used one, but now i think i need one. a delete query.

what my setup is at the moment is a table has had a make query table used on it to produce a very similar setup table, containing the same information using an append query, but less fields due to not wanting them on a view only form. when someone has enterd into the original table's dataentry form, it is appended to the query table, after that, it may be deleted, now what i want is for that record, if not found by the same ID to be on the original table, to be deleted from the query table.

ive took a wild guess at that will need a delete query, but i can only make one as far as it asking me what it wants me to delete.

thanks to all who post and gratitude for helping.

Callum.

 

[Galaxiom]

You are making this unnecessarily complicated. There is no reason to make tables for what you have described. You should simply be using an ordinary SELECT query on the main table as the RecordSource of the form.

Then you won't need the delete either. Addding and deleting records all the time bloats the database and should be avoided.

 

[Callum]

but then i would need to make the query into a table, im using access in conjunction with a GIS so i need a table to upload, not a query. this is the dilemma. thanks.

 

[Galaxiom]

but then i would need to make the query into a table .

... And this is a bigger problem than the convoluted process you have described?

It seem I don't have enough information to understand the problem.

One thing for certain you should not be creating a table simply to reduce the number of fields on a form.

 

[Callum]

i need it to be automatic, i can have querys bound to open when the database is opened, or maybe when a form is closed. can i make a table out of a query if the table it will be replacing is opened in another linked database? i have already done the selecting and then just making a table out of it, but that is NOT enough for what i need