What I want -- what I really really want -- is some way to have more than one sub-datasheet for a table/form. Access 2000/2002.
I have a DB with one primary table in one to many relationships with about 3 - 4 other tables, all using the same key. I desire to display these child tables off of the records in the parent. Ideally, I would also like to be able to find/replace, filter, and sort the parent table based off of values in its children. VB has something cool called a hierarchical flex grid control that looks really neat, but I have had nill success in getting that route to work. Any ideas? Am I over looking something easy and obvious?
--Waste
I have a DB with one primary table in one to many relationships with about 3 - 4 other tables, all using the same key. I desire to display these child tables off of the records in the parent. Ideally, I would also like to be able to find/replace, filter, and sort the parent table based off of values in its children. VB has something cool called a hierarchical flex grid control that looks really neat, but I have had nill success in getting that route to work. Any ideas? Am I over looking something easy and obvious?
--Waste
