Hey folks. thanks, a lot of that helped. i further have realized that the behavior is NOT the same between v2 and v3 (yea!)
it actually works fine in v3, it just didn’t appear to at first (because i didn’t read fully).
again, the situation is something like this:
tableA, colA1 -pk, colA2 (unique NN)
tableB, colB1 - pk, colB2 (want this to be a FK to colA2 in tableA)
what we need to do is something like:
Alter table “tableB” add foreign key (“colB2”) references “tableA” (“colA2”)
in V3, when i create the relationship, it first assumes i’m going to have a foreign key in tableB using a column named colA2. however, if i go to the Foreign Keys tab, although this looks the same as v2, it has an (apparently) new feature. it says to press f2 to change the selected child attribute. pressing that gives me a drop down list to select. i can’t find a way to do that in v2.
Thanks much. this is a great product, David Soniat