Itinerary

[WhiskyLima]

Hi All, just wanted to know how you guys would set about this kind of problem. I have a number of tables with different information in them, ie flights, transfers, hotel booking etc. Each of these is connected to a client and a particular event using a booking reference.

What I would like to try to achieve is to collect all of this information and create a list of everything that is happening in order of date.

For example if I have a flight in one table and a transfer in another I would like to be able to create a report with that information listed in order of it's date and time.

What is the best way to tackle this kind of thing?

Thanks all.

 

[Minty]

Create the individual queries against your tables, I would ensure you return the same fields for each query.
You then either use a Union Query to join these into one result set, or possibly depending on your needs, put the results into a temporary table then use that to perform more steps.