Hello Folks,
I'm running Access 2007 on Windows Vista.
I have some experience with Access but it is some time since I needed to do something like this and I'd appreciate some assistance.
I'm a musician and I want to put together a database to hold details of Venues, Bookings and Comments about Venues.
I have three tables Venues, Bookings and Comments. All related by the field Club ID
For any Venue there may be several Bookings and Several Comments. There may be Bookings and no comments or there may be no Bookings and several comments.
What I's like to do eventually is have a form showing the Venue details and a couple of subforms one show any bookings one showing any comments.
My initial problem is that I can create a query that shows the Venue and Bookings. However, in datsheet and presumably form view it shows the venue name for each booking.
What I'd like to see is something like this
Venue A
Venue B Booking 1
Booking 2
Venue C
Venue D
Venue E Comment 1
Thanks in advance for your help.
MIke