Create a link to a complete record in another table

[Rich]

Hello everyone,

I am working on a database that has 3 tables for equipment, supplies, and
personnel. There is a 4th table for contact information for the other three
tables to link to. I have a relationship set up with all of them which gives
me a drop-down box to select the correct contact for the respective
equipment/supply/personnel record.

What I want to do is have a link from that drop-down box in the
equipment/supply/personnel record to the appropriate Contact Information
record in the other table. Is there any way to do this? All of my searching
keeps turning up how to insert hyperlinks and how to link to other databases,
but not how to bring up a complete record in another table.

Thanks everyone for your help!

Rich Ochs

 

[Fred]

I noticed that nobody answered.

If you will forgive me, your description of what you're trying to do sounds
really mixed up. And rather than describing what you are trying to do, you
are really describing how you are trying to do it. (dropdowns, links etc.)

May I suggest telling us a bit more about what your data and what you want
this database to do?

Mos likely you need a table with contacts which has a primary key (e.g.
ContactNumber ), and a field in thie other tables which contains the contact
that they need to look to. Creat these three links in the relationships
window. The you really have to decide.... do you really need to create new
records in those other three tables and THEN link it? A simpler way is to
just create the new record "underneath" the contact, and have the
COntactNumber automatically loaded into the new record. If so, creat a
"Contacts" form, and into it put subforms for those other three tables.
Then just go to the contact, add the record in the subform, and the task that
you describe will be handled automatically.

 

[Evi]

Rich, are you saying that the Wizard set up your table links for you (giving
you nasty little drop down boxes in your tables and making you think that
you don't need a form to input your data) and now you want to add a fourth
table and perform the links manually?

The main question is, what do you mean by Contact Information.
Do you mean addresses and telephone numbers for Personnel, Equipment,
Supplies?
If you mean people, are the contacts also personnel?

Evi