B
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!
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!