Simple form query (Hopefully)

[optimus_1]

Hello

I am new to Access and am unsure as to how i acheive my aim.
I have attached a copy of my example database.

Query:

I have a table (tbltoolsCategory) that i want to be a parent link to other tables (tblChainsaws, tblStrimmers, etc) within the FORM (Date and times).

for example if i choose 'Chainsaws' from tbltoolsCategory drop down then i want the tblChainsaw options to appear rather than be there already as it is in the attached database.

Also i evidentally need to assign hours used on these 'tools' which maybe someone could help me on how i best do that.

Really hope that makes any sort of sense!, If not please ask me to elaborate

Thanks in advance
Nathan

 

[Rich]

You don't need separate tables for each type of equipment, just another field to describe the equipment

 

[optimus_1]

Thanks Rich

I think i know what you mean but i will need to report on specific types of equipment and thought that using a 'category' table this would be easier to do.

I am more than probably incorrect but i am not that experienced with Access.

My problem with the form is that one person may only use one piece of equipment wheras another person my use several so i could really do with an option to 'add another line' or something like that. How would i go about that?

Cheers
Nathan