K
Kerry Purdy
Hiya
I have got so far with designing my database, forms and reports and now have
a problem. I am not sure whether i need to jiggle around with the tables and
relationships or whether is a report problem. I will try to explain in as
best detail as poss...
I have a Room Booking Table using RBID as the Primary field (Client ID, date
of booking etc.)
I have a room Requirements table using RBID which could have mutliple dates
and multiples rooms against these dates e.g. 08/05/06 - Room 1, 09/05/06 -
Room 1, 10/05/06 - Room1, 10/05/06 - Room3
I have Resources Rqd table using RBID which could have multi dates and multi
resources (08/05/06 - Flipchart, 09/05/06 - Flipchart, 10/05/06 - Projector,
10/05/06 - Other
I have a Catering table using RBID which would only have one entry per date
(08/05/06 - Pub, 09/05/06 - Pub, 10/05/06 - Buffet)
All is working well as far as input is concerned but its the output i am
having terrible problems with. I am trying to create a report to be a Room
Booking form which will have all the details on one page, this will the be
printed and signed etc.
When I try to report on the room, resources & catering requirements ideally
I would like a list that shows as:-
08/05/06 Room 1 Pub
09/05/06 Room 1 Pub
10/05/06 Room 1 Buffet
10/05/06 Room 3 Buffet
what i am getting is a HUGE list of items with a record for each room
booking a record for each resource and another for each catering requirement
- repeated about 4 times.
Should I have formed some sort of relationship on the dates as well as RBID?
Have I designed this database badly - do i need to start again?
Is it just a grouping option in a query or on the report to get what i need?
I hope this makes sense
Thanks so much for your time.
Kerry
I have got so far with designing my database, forms and reports and now have
a problem. I am not sure whether i need to jiggle around with the tables and
relationships or whether is a report problem. I will try to explain in as
best detail as poss...
I have a Room Booking Table using RBID as the Primary field (Client ID, date
of booking etc.)
I have a room Requirements table using RBID which could have mutliple dates
and multiples rooms against these dates e.g. 08/05/06 - Room 1, 09/05/06 -
Room 1, 10/05/06 - Room1, 10/05/06 - Room3
I have Resources Rqd table using RBID which could have multi dates and multi
resources (08/05/06 - Flipchart, 09/05/06 - Flipchart, 10/05/06 - Projector,
10/05/06 - Other
I have a Catering table using RBID which would only have one entry per date
(08/05/06 - Pub, 09/05/06 - Pub, 10/05/06 - Buffet)
All is working well as far as input is concerned but its the output i am
having terrible problems with. I am trying to create a report to be a Room
Booking form which will have all the details on one page, this will the be
printed and signed etc.
When I try to report on the room, resources & catering requirements ideally
I would like a list that shows as:-
08/05/06 Room 1 Pub
09/05/06 Room 1 Pub
10/05/06 Room 1 Buffet
10/05/06 Room 3 Buffet
what i am getting is a HUGE list of items with a record for each room
booking a record for each resource and another for each catering requirement
- repeated about 4 times.
Should I have formed some sort of relationship on the dates as well as RBID?
Have I designed this database badly - do i need to start again?
Is it just a grouping option in a query or on the report to get what i need?
I hope this makes sense
Thanks so much for your time.
Kerry