Making a new table

[Kay Davies]

this is a bit complicated but I will try to be clear.

I am linking to four tables in anther table. I have set up
forms and subforms based on queries using a mixture of
fields from various linked tables. I get back the data I
expect so all fine there. I now want to create a new table
that I can add a field to but which contains some of the
linked data. I have no idea if this is possible. Ideally
on closure of the form this data would automatically be
copied into the new table (within the front end). I need
this so that I can add a check box and then generate a
report (I don't want the check box to appear in the back
end)

If anyone has any ideas on whether this is possible I
would be very grateful. Many thanks. Kay

 

[John Vinson]

I now want to create a new table
that I can add a field to but which contains some of the
linked data.

Use a MakeTable query. It can use a field or fields on your form as
criteria, and can be executed from code or from a macro.

Create a new query joining the tables containing the data you want to
copy, and use the Query menu option or the query type tool in the
toolbar to change it to a MakeTable query.

To run it repeatedly, you will need to delete the table before running
the maketable query; you should also compact your database frequently,
since the deleted table's space is not recovered.