Relational Tables

[soprano]

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

[June7]

Need a field in tbl_bookshelf for the floor ID.

Need a field in tbl_shelf for the tbl_bookshelf ID.

Need a field in tbl_box for the tbl_shelf ID.

[soprano]

Thanks for reply!

But how i use this field? I created id in all tables!

Thanks

[June7]

This field will store the value of primary key field from related table. This will be the foreign key field that will connect to the primary key field of related table. This is how relational database works. Tables are related by fields with common data - the primary key in one table and foreign key in other table. Understanding keys is critical. Maybe this will help http://www.rogersaccesslibrary.com/