Is Subtable possible?

[froggiebeckie]

Hi all!!
I've inherited a new db that was created by folks fresh out of school.
I've been looking through it, checking to see how they built it, trying to scope out any neat and nifty new tricks they've used, before something goes wrong and I have to work on it.

They have a table that displays grouped records, and I'm not sure how they did it.

For example:
In the PRODUCTS table, the first record is for [Product Type] "Sticky Stuff", [Product Name] "GooGoo", [Manufacturer] "XYZ Co.", etc, with a + sign in front of the record.
When you expand the record, you get what looks like a sub-table listing all the transactions having to do with "GooGoo".

While trying to figure out how they got this effect, I checked out the Inventory Management sample db that's available on-line. They also have this type of grouped records in a product table.

Is there a simple explanation of how this is done, or do I need to invest some serious study time?

As always, thanks for any guidance you can give me.

Froggiebeckie

 

[KenHigg]

When you set up a one to many relationship in Access in 'Relationships' view this is the view you get by default. If that is a bit fuzzy for starters then maybe a little reading on 'relational databases' and/or 'normalization' would help you get the picture... Hope that helps

 

[froggiebeckie]

Thanks, Ken!
I actually looked at the relationships, and recognized the one-to-many, but lost that train of thought.
Major senior moment, I guess.

Thanks for turning me back around.

Froggiebeckie

 

[KenHigg]

Major senior moment...

Been there -