Hello I am new to the forum!
I have a problem and together that is due to relational tables!
I have the following table structure!
tbl_floor - name and description;
tbl_bookshelf- name and description;
tbl_shelf- name and description;
tbl_box - name and description;
I need that when you insert a new box in the same table tbl_box allow me the following!
Choose the floor, on the bookshelf column appears only shelves that are on the floor I chose earlier! By choosing to stand only are loaded in the column corresponding to the shelf bookcase that chose above!
To do this type of database just me this table structure? Or need something more?
Thanks to all