>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
Even more classical solution would be to use the location table twice (aliases, say, Location and Location2), and have
Grid.ColPickup.controlsource="iif(seek(pick_up,'location'), location.loc, '')
Grid.ColDropoff.controlsource="iif(seek(drop_off,'location2'), location2.loc, '')
...without any additional function to write. The view remains, of course.