Here's the setup:

I have a trips table, which contains information about each trip, including the fields "pick_up" and "drop_off". These fields are integers to hold the key from another table, locations.

I have a grid and I want to show these trips with locations.loc in place of trips.pick_up and trips.drop_off. The pickup and dropoff fields refer to _different_ records in the locations table.

Since everyone convinced me to use views, that's what I'm trying to do. In the view designer, I have 3 tables: trips, locations, and locations_a. I join trips.pick_up to locations.lockey, and trips.drop_off to locations_a.lockey.

It saves, and doesn't give me an error, but if I try to go back into it, it says "trips.pick_up not found" and clears out everything except the tables. If I join them to the same fields, but do it in the reverse order, it tells me it can't find trips.drop_off and does the same thing.

Any ideas?