Base - Renting and calendar

[nanouch]

Hello,

I would like to create a database to handle different rentings.
Here are more details :

I have two kinds of talkie walkie, and about 200 talkies of each kind.
I need to create a database that would allow me to handle the renting of these items, and if possible to have a clear view of the dfferent renting on a calendar.

I think I will need three tables :
- talkie (serial number, company number, kind of talkie : GP340 or GPP340 atex)
- renting (case number (generated by the base), client, dates, company number of the selected talkies)
- client (name, adress)

the problem is mainly how to insert a calendar (if posible)

thank you for your answers.


(sorry if there are some faults in my vocabulary, I'm not english but i've done my best

[Villeroy]

You can't get any calendar sheets in cross-table layout (e.g. weekday X time).
The best you can get is an ordered list of dates, times, events for a given time span. You may dump the listing into a report and group by months, weeks or days but it will always be a vertical list.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org