linking 3 forms to move to the same record

[levi]

When using my database I have 3 main forms, filing them in
is easy a start up form comes up with built buttons to
open 1 form then the other. What I want to know is using
the same designed forms when searching in 1 form can you
make it scroll in the other forms to the same record
i.e.... I have a form named details for name address etc
then one for work details caring info where they work
etc.. Then one for union details with info on whether
active how much they pay etc.. All related by membership
number and all carrying the membership number Field and
sorted by membership number but at the moment if I wanted
to find someone's name I can find that in the details form
say they were in record 21 I would then have to move
manually to record 21 in the works details to find out
about where they work is there any way that it can be done
automatily??????

 

[Bruce]

How about a tabbed subform for the work details and the
union details? Or maybe it doesn't need to be tabbed, if
you want to see all of the information at once. If the
underlying tables are properly constructed and linked, it
could be as simple as dragging the Work and Union form
icons onto the Name form in design view.

 

[Guest]

i have tryed the tabbes thing but don't like the look of
that i will try the other sejestion as far as constructed
correctly i dont realy no as this is my first time i have
ever used access you can take a look if you like ?

 

[Bruce]

Please post the basic structure of your tables. Include
the names of the primary key field(s) in each, and a few
other typical fields or fields that are part of your
questions. It is not necessary to include every field in
your post. For instance, Name and Address are sufficient
for our purposes. It probably does not matter in this
context that you have fields for FirstName, LastName,
MiddleInitial, etc.
After you have done that, describe what needs to be done.
For instance, is there to be more than one job (work
detail) per person. If so, are they all to be viewd, or
just the latest one. How many Union details need to be
seen? Do they need to be seen every time the person's
record is viewed?
You should be able to see and work with all of a person's
information from the same place. If you can't, let's fix
that.

 

[levi]

First of all i am off on holiday for a fortnight so won't
reply after this for a while.
right lets go i have one table called tabdatails with name
address email, membership, company DoB ect
table 2 is work details called tblwork details includes
membership number NInumber, companyid, company, work
location job1 and job 2
the next table is union details is called tblunion details
includes membership number amount pain joining date tick
boxes for left, active, and different payment types and
field for union position
and a few other tables which contain the info for some
drop down combo boxes like all the companies information
The membership number field is the primary key in all the
tables and is joined by a one to one relationship.
not all the records needs to be seen at the same time
other than when updating the system with a new member.
i do need a easy way to fined records by various ways
some i have set up queries for ie all members that work at
one location or all members that work for one employer
doing the same job etc or by name and address and of
course membership number
At the moment i have it set-up like this if i can describe
it correctly
You start up with the switchboard from there you have a
choice whether to look at and print some of the queries I
have done, Or just look at the members details which
comes from comes (from the tabdatails table) on the form
I have put a button to bring up the other two forms union
and work (1 at a time ) the problem is when your loking
for a member by name you can use the find short cut
ctrl+f in the details form but then when you use the
button in that for to find where they work you have to
scroll threw to the same record number manually IS THER
A WAY TO DO THIS ATOMATICLY
I must say thanks for your all your help and under standing
Ps I also tried the way you suggested dragging the union
and work icons in table design mode but could not get it
to do any thing maybe I was doing that wrong.


inal Message-----