>Views are not stable in intricate situations. Probably, this is one of them. The feasible (there other ones) workaround is following:
>1. Make view based on just one 'trips' table, or you can even use just this table itself (no view at all).
>2. If I remember right, you want to bring the data into grid. So, you make Grid.Recordsource="trips"
>3. You have two columns which should show data from two other tables, and you set custom controlsources for these columns:
>Grid.ColPickup="Thisform.SetCustomColumn(trips.pick_up)
>Grid.ColDropoff="Thisform.SetCustomColumn(trips.drop_off)
>4. Form.SetCustomColumn method
>LParameter nLocationid
>Select Location
>Set order to tag lockey && it's faster to use SEEK() function here
>Seek nLocationid
>Return Location.Loc

So no views this time? (sigh)

Thanks,