General discussion

Locked

Multiple Unrelated Tables Access 97

By MRA2 ·
I have an Access 97 database with two tables. One Table is Clients the other one is Volunteers who might help a client. I made a clients form and put a button on it. The button takes you to the Volunteers form. Now I search around and find an appropriate volunteer. I want to capture that Volunteer's First & Last Name and be able to put it in a field on the Client form.
Any ideas would be greatly welcomed!

Thanks,
Alan

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Multiple Unrelated Tables Access 97

by Bristar In reply to Multiple Unrelated Tables ...

Have you considered the wonderful joys of a Combo box? You can list multiple columns inside of it and just select the volunteer you want on your Client form.

If you want a more customized search menu, you can save from one form to another by simply referencing the form and element.

Collapse -

Multiple Unrelated Tables Access 97

by MRA2 In reply to Multiple Unrelated Tables ...

Poster rated this answer

Collapse -

Multiple Unrelated Tables Access 97

by R. A. Caluste In reply to Multiple Unrelated Tables ...

well, you can reference both your forms' controls programmatically through event procedures. Under
the onclick event of a command button,
set:
Form_clientformname.field1 = form_volunteerformname.lastname (or me.lastname)
and
set Form_clientformname.field2 = form_volunteerformname.firstname (or me.firstname)

hope this helps.

Collapse -

Multiple Unrelated Tables Access 97

by MRA2 In reply to Multiple Unrelated Tables ...

Poster rated this answer

Collapse -

Multiple Unrelated Tables Access 97

Take this scenario:
Your clients are retirement homes
Your volunteers want to do their stuff near where they live or in specific areas.
In this case you would check the general areas of both the clients and volunteers.
Then, when you call up a client, you can see which volunteers live or will work in the area.
To do this, I'd use a tabular sub-form on your client form showing the list of volunteers in your client's area. All that is necessary is to
specify the Link Master Fields and LinkChild Fields properties in the sub-form.

Hope this helps
John

Collapse -

Multiple Unrelated Tables Access 97

by MRA2 In reply to Multiple Unrelated Tables ...

Poster rated this answer

Collapse -

Multiple Unrelated Tables Access 97

by MRA2 In reply to Multiple Unrelated Tables ...

This question was closed by the author

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums