Hi Jiri,
Many thanks for your posting. Since you have experience in this field could you take a look at my latest design effort attached.
I have taken tblOrders out to be replaced by a larger tblReservations, as you suggest this keeps all the booking data in one place it also acts as the basis...
Hi All,
My 1st post so excuse any obvious short comings, and I am just learning Access so I imagine you may have to be patient with me!
Basically I am trying to design a hotel style db for my business but am getting very confused on the initial table and relationship design that I should be...