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
Bill Morris