Recent content by Puffet

Hi Mr B Great. As per your suggestion I tried an additional table with many keys and it is working like a charm.:) Much appreciated Puffet

Thanks for the reply, Well I need it so that I can have as follows: I create a booking In this booking I attach a room and attached to each room is one or more guests. I presume I need a booking table, a Guest table and a Room table but how do I link these up so that I can have this...

Hi, I have seen many examples of a booking system designed in Access but the situation I need is a little different and I can't seem to get my Tables and Relationships Right. I need to set up the System so that One Booking can have many guests and each guest is allocated a room. The issue...

Hey thanks for the quick reply. I feel welcome already. In summary I aleady have a subform but the subform does not have all the data I want. So I am trying to pull through extra data relating to the record via a Dlookup. I cant get the Dlookup to work. I need to fetch the Guest_surname...

Hi, I am an excel VBA dude who is new to Access and I am loving it. A whole new world out there to get my teeth into. :) I have my first big problem and I need some advice. :rolleyes::mad: I need to write a Dlook up and I am not getting it correctly. The dlookup will reside in a text box...