Thanks for your comments. Here's the main table (Facility) and one of the
services tables, with its associated reference table. I didn't want to throw
everything at you!

tblFacility
FacilityID (PK)
facilityName
FacilityTypeID
FacAddress1
FacAddress2
City
State
ZIP
Telephone
Fax
County
LongTermCare (a yes/no)
Status (rural or frontier)
MUA (a yes/no)
HPSA (full, part, no)
MHHPSA (yes/no)
DHHPSA (yes/no)
RuralIndex (a number)
WebSite (if the faciity has one)
Email (ditto)
Comments (a memo field containing community demographic info)
FulltimeRNS
ParttimeRNs
FulltimeLPNs
ParttimeLPNs
FulltimePersonnel
ParttimePersonnel

tblGeneralServices
FacilityID (these two are combined
GenServiceID to be the PK)
GenServiceName

reftblGenServices
GenServiceID (PK)
GenServiceName

Again, each facility can offer more than one general service.

To assign the record source, that's the right-click on the "square" at the
left corner of the design area, select Properties and give the name of the
table that is the source for the data - correct?

rpw wrote in message
...
You've got quite a bit going on here - where to start?

The "Fields List" will not appear until you've assigned a record source to
the form.

When you are using the Tab control on the form, if each tab will display
information from different record sources, you will need to build the
sub-forms first and then place it on the tab page of the main form.

If you'd like the newsgroup people to offer assistance on your table
structure & relationships, then post a listing of the tables in the
following
format:

tblFacility
FacilityID PK
FacilityName
FacAddress
'other fields that describe facility...

tblFacilityServices
FacilityID FK { these two fields are
ServicesID FK { combined to be the PK

In the above example, it's easy for the readers here to determine which is
(should be) the 'one' and which is the 'many'.