Adding additional Row into Table after new row has been entered

[bjwheeler]

Hi there,

This might sound like a illogical way of doing this however... what im
looking for is the following:

I have one table" Associates" with the following fields:

ProfileID
AssociatesProfileID
Surname
First Name
DOB

This is behind the "Associates" Form. This form is a sub form of the
"Profile" Form.

When a user is entering data in Profile A in the Profile Form, and
they click into the Associates sub form, all the Associates Profiles
(Profile B etc) linked against Profile A are listed and can be opened
from the associates subform to the main Profile form. This works like
a charm.

However, when the user has Profile B open in the main profile form,
and they click on the associates tab, the associate Profile A is not
listed. - This is because there is no row entry in the associates
table.

So what im wanting to know is.

How can i get access to automatically insert another row in the
associates table once the user has finished adding a new associate
that swaps the newly created row AssociatesProfileID and Profile ID
around, so when they open up Profile B in the main profile screen, it
is automatically there..

Is it an Append query? or after Insert? or something?

Sorry im in over my head here!

thanks very much!

 

[Rui]

Assuming you have the data available, you could do run an insert command into
the table followed by a requery (to make the data visible).

Hope this helps
Rui