Thanks for the very speedy response Allen, much appreciated.
I was a bit brief and vague on what I wanted to acheive -
Doing a DB for coach tour bookings
Tour Table - contains spec / costs / venue etc
linked to
Booking - Main - contains lead customer details, booking
date etc etc
this links to
Bookings - extra - contains individual passenger names, seat
number
pickup, room types etc
My main form has a sub form which is for the data that I type into Bookings
- extra, and as I need to keep peoples names in the order I type them into
the Form for rooming requirements. Up to now I have an initial field I type
from 1 to ...
so that when I do a query or report based on the booking ref lines of entra
in Bookings - extra it brings them up in the same order as input (which isn't
alphabetical or anything)
Hope that explains it a bit better - would that need a different way of
numbering >?
Thanks again
DK