Form Linking

[arthurgrajeda]

I need assistance in linking forms on a database I am building.

Form number 1. is My form in which I call "company name". It is a brief
overview of the company's information.

Then It has an employees button which links to a from that has the
"employees names" & "company name" and a "profile button".

When you click on the "profile button" it goes into a form that has
specifics on the employees which is called "employee profile".

This was the easy part.

I need to know how to link the forms together correctly. I am using the
"company name" as my primary key.

I would like to be on company (ABC's profile) and when you click on the
emlpoyees button it would list only the employees for that company,
then when you click on one of the employees profiles it would pull up
the form on that employee only.

Is this possible any help would be greatly apperciated. Thanks Arthur
Grajeda



I hope this makes sense.

 

[tom]

I don't know what you mean by linking forms together. Do you mean just
filtering records to specific parent records? Have you considered using one
form with a subform on it. e.g. the parent form has details of all Companies
with a subform detailing their employees? A double-click event on the
employee name could open a new form with their details... (perhaps with
security?) but maybe a second subform (on the first subform) would be easier
and quicker to use? Select an employee and the second subform would display
their details...

HTH.

Tom.

 

[arthurgrajeda]

I did see the subform on the northwind example. I just would rather have
it in different forms.

I guess the filtering would be more on the lines on what I am
discussing. Let me give an example. Maybe a subform would be better.
Let me know.

Form 1 (office)


ABC company
adress
phone numbers
etc

Employees 5 with a employees button next to it.

when this employees button is clicked it would pull another form up
called (employees). The hard part is trying to get just the employees
for ABC to pull up.


Then when on the employees page it would list the employees
individually.


john smith (profile)

fred tom (profile)

earl johnson (profile)

When the profile button is clicked it would bring up another form
(emloyees profile) for the selected employee.

Am I going about this all wrong. Any help to a better way of building
this would really help. Thanks

 

[tom]

You could do it this way, but unless it's for security reasons, e.g. hiding
certain info and only making it accessible to authorised persons, you would
be better placing the information into subforms contained on the parent
form. If I were you I would have a parent form with company information on
it, with a few Tabs (pages) containing the additional information as
required. I would then test the permissions of users and determine which
pages I would make visible to them, and hide the pages to which they have no
access.

Maybe it's just me, but I feel having dozens of buttons around is very
tiresome and only slows the overall process down... in the end I tend not to
want to work in the application! BTW, opening forms based on the Parent
form's Primary key is not as difficult as you may think... Just specify the
field in criteria on the subform's query grid of it's RecordSource.

HTH.

Tom.