Hi Allan,
It's not possible just to make a change in one Access table and have
something automatically happen in another table.
To do things along these lines you have to use forms to display the data
in the tables. For instance, when you alter the data in a record
displayed on a form, a BeforeUpdate event fires just before the data in
the table is updated, and an AfterUpdate event just afterwards.
So it might be possible to use VBA code or a macro in the AfterUpdate
event to run an Append query that took some of its parameters from the
form to create a new record in the other table. Or it might be better to
put a button on the form and use its Click event.
But to make the best use of Access you probably need to think more
carefully about your data and the situation you are modelling. For
instance, does each record in each table include the client's name and
address? If so, you've almost certainly taken a wrong turning: in
Access, you'd have one table for the Clients (or People or whatever) and
- probably - another one for Visits, with a field to show what kind of
visit it is (new attendance, scheduled re-attend, etc.) The two would be
linked by a ClientID field.
Take a look at the Northwind sample database and see how it's put
together, with each "entity" (person, company, product etc.) having its
own table and each piece of data stored only once. When you have more
questions, post in microsoft.public.access.gettingstarted and there'll
be people ready to help.
I have tried everything I can think of! Please can someone
help.
My problem is this:
I hve 2 tables in my database. 1 is for new attendances
the other is for scheduled re attend visits.
Within the new attendance table there is a check box for
if a re attend visit is advised.
What I want to happen is that if this box is checked, the
information from the original table / form transfers into
the other table effectivley booking them a reattend
appointment.
How can I do this - please tell me!!!
Allan
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.