Table Setup Advice

[bsbuchan]

I'm building a database for my boat rental. I don't really have any issues with the actual building of the database, however, I am, for whatever reason, unable to wrap my mind around the best way to set up my boats in a table. Here's what I want to do that I haven't been able to accomplish on my own yet.
Have a boat table or tables that track each category of boat (pontoon, ski boat, waverunner).


Table for each boat in each category (pontoon 1, pontoon 2, pontoon 3...) I'd like to track maintenance and hours for each boat.
Table for each boats hourly pricing structure (Pontoon 1hour=$50,4hour=$150, 8hour=$230)
I'd ultimately like to create an invoice where the employee has a combo box, clicks on a "boat box" which pulls up each craft. Let's say they click on pontoon. Then have another box that would display pontoons 1-6. Another box for pontoon rental duration ( 1hour=$50) (the prices would have to be specific to each boat-ski boats have a different pricing structure than pwcs and pontoons)
Optimally, when the employee fills out an invoice and the customer rents pontoon 1 for 4hours, then pontoons 1's table keeps track of how many hours have been put on it so we can have accurate maintenance reports.
Any help would be much appreciated

[June7]

Looks like lots of issues to me. All can be done but you need to understand relational database principles.

Review:

'Sticky' threads at http://forums.aspfree.com/microsoft-access-help-18/

Demo and tutorial threads at http://www.developerbarn.com/communi...oft-access.24/

http://office.microsoft.com/en-us/ac...010098674.aspx

http://office.microsoft.com/en-us/ac...010341717.aspx

http://datapigtechnologies.com/AccessMain.htm

[bsbuchan]

Thanks! I'll look over the material you sent my way.