>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?
Michelle
May be some trick with the view designer will help you.
Add tables to your view in this sequence:
1. locations
2. trips
3. locations
The SQL statement (from the view designer):
SELECT Trips.name, Locations.loc, Locations_a.loc;
FROM data1!locations INNER JOIN data1!trips;
INNER JOIN data1!locations Locations_a ;
ON Trips.drop_off = Locations_a.lockey ;
ON Locations.lockey = Trips.pick_up
I have tried it. It doesn't give an error.
Sorry for my English.
Ura
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement