Access Design

[SHETTY]

Dear Friends

We are in advertisement business -hiring own sign boards to our clients. our
boards are booked by clients on monthly basis at a perticular rate per
month. More than one boards are booked at once.

We have to verify wether particular board is occfied/vacant? when it will be
free for booking to next customer ? etc. All the boards booked will be
billed to customer as and required.

So I am looking for a model desing/template
Any idea please advise to me, If anyone has developed similar model please
help me,

Thanks

Ramesh Shetty

 

[scubadiver]

The basic design as I see it is a many-to-many relationship

Each client can have many boards
Each board can be booked to many clients

tbl_client
clientid (PK)

tbl_board
boardid (PK)
monthrate

tble_booking
clientid (FK)
boardid (FK)
startdate
finishdate
cost

 

[scubadiver]

consider putting the fee of hiring the board in with the booking table so if
it changes at all then historical cost information will remain accurate.

 

[SHETTY]

Thank you

consider putting the fee of hiring the board in with the booking table so
if
it changes at all then historical cost information will remain accurate.