Hello,
First of all let me state that I'm a newbie in the Access world so please excuse my incompetence generally speaking.
Now let me explain what I would like to create, some days ago I got a Sony photo camera that got a massive menu structure that is, in my opinion, poorly dealt with in the current Sony PDF manual. For the most part a PDF is a document that does not fit well the level of complexity of Sony cameras menu, which, by the way, now is standardized along their product line, so one manual should fit all with some caveats...
The camera menu structure is very similar to what you would see in a PC folder structure with up to 7 levels of indentation, so pretty deep if you ask me.
How would you design the database?
What I currently have is 5 tables, 4 that contain each menu level (there are still 3 levels missing because I'm not sure that my approach is actually ideal) and one table that contains the relationships in between the other tables (what menu option is "hanging" from whatever higher level). Would you say that my approach makes sense?
So far I have been inputting the data directly in the tables because I'm used to Excel but as you can Imagine as I go deeper in to the menus it becomes more difficult to track what I have and what I haven't done... so I guess I should provably be using form to properly input data in to the tables but unfortunately I'm unsure on how to tackle the task.
Many thanks and best regards.
Isaac