Linking to another Form

  • Thread starter Thread starter Tucker
  • Start date Start date
T

Tucker

Hi all,

I have a database being used as an information retrieval system. Users don't
add anything, just look up process, phone numbers etc.

On my primary form I have a field that if the information sheet (or record)
they are viewing has a link to another record then the name of this record
appears in the field (I enter this into the back ground table).
All the user has to do is click on this and that record opens up.
It is the same form, just new info on a relevent topic.
I can't get this to work as some records won't have anything and others will
have a link to a relevant page.
Any assistance would be appreciated.
I've tried a bound text box, then hyperlinking it but I have no idea how to
connect what is in the field to the actual record (there is a primary key -
record ID). Am I on the right track???
 
Try a mainform and subform. Mainforms are designed to be the "one" side of a
one - to - many relationship and the subform the many side. When you link
them properly, anytime a user clicks on a record in the mainform, all the
data associated will show in the subform.
 
Thanks Golfinray,
Subforms wasn't what I was quite after. (Use these all the time).

Think of this field as the title/clickable link to a "see also" page in a
manual.
In this case the information (or record) is actually presented on the same
form.

eg.
Form [Frm_MainData]
has a field called [Title] = Possum Guards
Then a field called [LinkedInfo] = Service Desk

When you click on [LinkedInfo] = Service Desk
Form [Frm_MainData] opens again
This time field called [Title] = Service Desk
(As Service desk handle possum Guard installation, these 2 records are
"linked")

Hope this makes what I'm trying to do a little clearer..

Any Idea's? I'm loosing hair, teeth and fingernails over this!!!!
 
Back
Top