One Form to enter/get data in two linked tables with 1 to many lin

[John L]

Hello,

I am a new user with a variant of a contacts database.

Table 1 Hospitals, with one primary contact person info.

Table 2 Volunteers in the hospital, can be many

How would I go about designing one form which allows entry of the volunteer
information, assigns an existing hospital or can create a new hospital with
the volunteer information.

On retrieving a volunteer's information, it must display the
hospital/primary contact information.

TIA,
John

 

[John W. Vinson]

Hello,

I am a new user with a variant of a contacts database.

Table 1 Hospitals, with one primary contact person info.

Table 2 Volunteers in the hospital, can be many

How would I go about designing one form which allows entry of the volunteer
information, assigns an existing hospital or can create a new hospital with
the volunteer information.

On retrieving a volunteer's information, it must display the
hospital/primary contact information.

TIA,
John

Since there's (apparently) a one (hospital) to many (volunteers) relationship,
you should start with a Form based on the Hospitals table, with a Subform
based on the Volunteers table. You'ld start by either entering or navigating
to an existing hospital, and enter the volunteer data for that hospital into
the subform.