newbie4access
Registered User.
- Local time
- Yesterday, 20:39
- Joined
- Apr 23, 2015
- Messages
- 25
On one of my old databases, I am trying to update from one crazy huge table to many smaller tables.
Because it's all about the Item, the ItemID (pk in Item_t) will be fk in many other tables (but not all of them) with a one-to-one relationship.
Thus when in datasheet view of my Item_t (table), I want to click the "+" for an item and see more detailed information ... Up pops this annoying "Insert Subdatasheet" box with all the tables (not just the ones w/ the fk ItemID) and queries.
Is there anyway to see multiple subdatasheets at once or must you pick one and be stuck with it?
Thanks!
Because it's all about the Item, the ItemID (pk in Item_t) will be fk in many other tables (but not all of them) with a one-to-one relationship.
Thus when in datasheet view of my Item_t (table), I want to click the "+" for an item and see more detailed information ... Up pops this annoying "Insert Subdatasheet" box with all the tables (not just the ones w/ the fk ItemID) and queries.
Is there anyway to see multiple subdatasheets at once or must you pick one and be stuck with it?
Thanks!
