Query output for forms & reports

[Dega]

I have one main form and three sub forms based upon CustID.

One sub form takes tour details from "booker" and "guest"

The other sub form takes room details from "booker"



The remaining sub form takes room details from "guest"

Everything works fine at this point and guest always is given a RoomGroupID and a RoomGroupName which is the "booker" LastName.

As up to four people can be in one room the "booker" is the team leader and the other one, two or three persons are "guest". There can be a dozen groups of various guest sizes (2,3,4).

I am trying to show all all those persons belonging to one group (RoomGroupName/RoomGroupID) on a form and more important on a report given to customers, but so far I can only get one record to show based upon the forms/report having focus on the CustID.

I had two records show at one time but have changed the query so many times ... can't remember how I did that even though it was only partly right.

My queries and tables output the correct data but once they are part of the form or report they show only single records associated with the CustID. I need all of those in that group to be shown.

Do I have to loop this query or something similar.

I am not a VB guy ...

Thanks

[NTC]

This isn't a VB issue. You discuss forms, but what is key are the tables. The table that holds Booker/Guests should list all their names, etc....with a field that identifies each as booker or guest, plus also a field that ties them all together into the same group like a trip ID.

(A more professional variation of this is if you have frequent repeat guests - such that it is better to have their data in its own standalone table, and make a 'transaction' table that cross references guests, trip ID, booker/guest role )

In any case; once you have all the participants tied together with a common TripID you should have no problem in a query to pull them all up together for a report.

Hope this makes sense.

[Dega]

Thank you for your suggestion and this is what I will do.

Cheers