I wondering if it's possible to have more than one subdatasheet for one table. My table relations are as follows:

tbl1: Offices
col1: ID (autonumber)
col2: Office (text)

tbl2: Sections
col1: ID (autonumber)
col2: Section (text)
col3: Parent_Office (number) (relation to [Offices].[ID])

tbl3: Staff
col1: ID (autonumber)
col2: Name (text)
col3: Parent_Office (number) (relation to [Offices].[ID])
col4: Parent_Section (number) (relation to [Sections].[ID])

As you can see the "Staff" table has two relations. One to the "Offices" table, and one to the "Sections" table. I'm trying this because this company has some employees under an office, and some employees under a section under an office. And in the end was hoping to be able to look at the "Offices" table, then expand an office to show both contacts related to that office, as well as sections related to that office.

Is this possible? Or am I beating a dead horse?

Help is much appreciated.

Liam.

The correct number of subdata sheets for a table is zero. These are horrid things invented by Microsoft to take novice users up entirely the wrong path.

Lookups should be performed in a form, at which point you can have as many as you like.

Look here for more reason not to: http://www.mvps.org/access/lookupfields.htm