>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only