I have a table with FKs in it.
I need an updateable view that has fields from the "parent" tables in it. Only 1 table needs to be updateable, the rest of the tables are just for display.

I have no problem doing:

select a.Fields, b.Field1, c.Field2 ;
  from a, b, c ;
  where a.FK1 = b.PK ;
    and a.FK2 = c.PK

but when I try to create it in the View Designer, sometimes I'll get c.Field2 and sometimes not. Sometimes it'll work for a while, but then I'll try to add a third FK and then lose c.Field2.

I really need to get 5 FKs to pull their respective fields into the View (2 from table b, 2 from table c, and 1 from table d).

TIA