Starting a Database

[Dowsey1977]

I am currently startinga database and only have 2 tables so far. Once has a long list of building names (with an autonumber) and one has a load of employees along with location names and various other bits of information.

I've seen it before, but can't work out how it's done, and that's to have a '+' column in front of all the building names so when you click on it, it brings up a list of names of people at that building.

Any ideas??

 

[Joe4]

You need to link your two tables by establishing a relationship between them.

In Access help, type in "Define relationships between tables" and it will describe in detail how to do this.

 

[Corticus]

It's a subdatasheet.

With the table open (in datasheet view), select insert|subdatasheet. If you have a relationship established as jmiskey suggests, the subdatasheet is already there, but if not, you can insert on in the method I described. Also, if your parent table is related to several child tables, youl have to tell the subdatasheet what related table to look at.

Once you've inserted a subdatasheet, you can edit it's properties under format|subdatasheet.