trevorhigbee2000
asked on
Change sub-table linkage in table view for a diagrammed set of tables
I have a nine-table diagram in access. It's hierarchical, like this:
Journal
--Article
--Section
--Category
--Etc.
So there's a one-to-many between journal and article, and there's a one-to-many from article to a bunch of sub-tables.
When I open up the Journal table, I get nice plus signs next to each record. I click on one of those and I get the articles in that journal--very cool. But then when I clicked on Article, it gave me an option to display one of the sub-tables, and I guess I chose to display the Category table under each article. How do I change this?
Journal
--Article
--Section
--Category
--Etc.
So there's a one-to-many between journal and article, and there's a one-to-many from article to a bunch of sub-tables.
When I open up the Journal table, I get nice plus signs next to each record. I click on one of those and I get the articles in that journal--very cool. But then when I clicked on Article, it gave me an option to display one of the sub-tables, and I guess I chose to display the Category table under each article. How do I change this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
IF I'm off here...I apologise...perhaps you want to configure the + sign action? if so, that's a master/child relationship built in your form that can be found by clicking on the top edge of the Category form and opening your Properties.
J
J
ASKER
Yeah. I'm not using a form. I wanted to avoid that. I just wanted to drill down within the actual table. Open up the table (not a form or a query), and use the little expander, collapser pluses and minuses. It works great until there is more than one "one-to-many" relationship coming off of a table. And then it doesn't know which table to connect to. I think I might just create a form.
I'll be honest....I've never seen a link table setup that had more than one child per parent. I didn't really play much with that. Direct access to tables is ok for those that know what they are doing...and don't need "controls" placed on them.
Forms manage a lot of the integrety of the tables if they are designed correctly. Plus if you have multiple tables under one...you can make 1 form with multiple tabs to house your subforms...it's really clean and navigation is easy. Plus it's all visual.
Anyway...keep this open so if you have questions about forms...we can answer them for you.
Just as a tip, use the Auto Form wizard to create your initial forms. It's fast, simple, and once all the forms are created, nested the way you want them...easy to move fields around. It just saves time.
J
Forms manage a lot of the integrety of the tables if they are designed correctly. Plus if you have multiple tables under one...you can make 1 form with multiple tabs to house your subforms...it's really clean and navigation is easy. Plus it's all visual.
Anyway...keep this open so if you have questions about forms...we can answer them for you.
Just as a tip, use the Auto Form wizard to create your initial forms. It's fast, simple, and once all the forms are created, nested the way you want them...easy to move fields around. It just saves time.
J
ASKER