Michelle,

It's a limitation of the kinds of views the View Designer can handle. Once you start doing any kind of 3 or more table joins you'll have to just create/maintain them in code:

create sql view windowsview as;
SELECT windows.iid, cWindowLetter,;
  nquantity, nwidth, nheight,;
  ncostpersqft, nPrice, lnameplate,;
  lprotectivecovering, llightbox, lframes,;
  lfinalmeasurement, ;
  CodesStyle.cValue as cWindowStyle, ;
  CodesTop.cValue as cWindowTop ;
  FROM  windows ;
  INNER JOIN codes as CodesStyle;
     ON  Windows.istyle = CodesStyle.iID;
  INNER JOIN codes as CodesTop;
     ON  Windows.itopshape = CodesTop.iID ;
 WHERE Windows.iproject = ?projects.iID ;
 order by cWindowLetter

>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?