You have Projects, Frames, Cabinets and Cards? All are in one Table?
It would seem Projects would be one table. Unsure how the others relate?
All Projects have a Cabinet? All Cabinets have Cards? All Frames have ?????
The first five links are likely to be useful.
Thanks for the links! *bookmarks* I'm sure they'll be useful!
Because I'm just wanting to use the DB for asset tracking I have all the different types of assets in one table. The only other table I've implemented is one to ensure valid devices are added to the main table. As 'Projects' is just a text field (I don't need to store anything else about the project other than it's name) I haven't given it a table because it would be a single field table - to validate this I've set the DB to offer a drop-down of existing values and to throw a confirmation-error when adding a new project.
Do you know of any scripts, functions or calculations that would allow me to, for example, update the value of child records when a parent is modified?