I work for a not-for-profit healthcare organization. I am fairly new at
using Access and I'm trying to set up a database of other facilities in the
region, using Access 2000. I need some direction and advice.

The main table contains facility information: address and telephone numbers,
web site address, number of full and part time personnel. It also contains
some yes/no choices, and a site ID (which is there to serve as the primary
key). There are tables for administrator names and contact info, director(s)
of nursing names and contact info. There are tables for Inpatient Services
(which each facility offers), Outpatient Services, Community Outreach
Services, and I'm sure you get the drill. Within each of those services
tables is a list of specific offerings, which each facility may or may not
offer. I have reference tables for the different services, within each
Service catagory, and I have (I think) junction tables for the data that
will, hopefully, accumulate. Within the junction tables are fields
containing FacilityID and ServiceID (each service being differently named,
of course). Each facility offers different service areas (inpatient,
outpatient, etc.) and different types of services within those service
areas.

I've been reading help screens and Googling groups, but I'm not
understanding how to accomplish what I need to do. I want to set up a form -
and I imagine subforms - to input this data. I wanted to use the Tab Control
for data input, because that appeared to be the way to go. A tab for
"general facility info," a tab for the different service types, a tab for
the administrator/director of nursing info.

When I am in Form design view, I don't have a "Fields List" icon on my
toolbar. I don't seem to be able to get the fields from the subtables to
join the party. I'm not sure that I have my relationships right. I have the
reference tables linked by ServiceID as the "one" side to the Patient
Services tables, which are linked as the "one" side by FacilityID to the
main table. Are my "ones" and "manys" backward?

Any help will be much appreciated.