2 tables:

A
ID NOT NULL
NAME NOT NULL
BID NOT NULL REFERENCES B(ID)
PrimaryKey: ID

B
ID NOT NULL
NAME NOT NULL
PrimaryKey: ID

IB_Query (LiveEdit=True):

SELECT A.ID, A.NAME, B.NAME
FROM A JOIN B ON (B.ID=A.ID)

KeyLinks:
ID

JoinLinks:
A.BID=B.ID

What needs to be done using this join query to enable editing of:

(a) A.Name;

(b) A.BID (ie the looked up name);

(c) B.Name?

TIA

--
Raymond Kennington
Programming Solutions
W2W Team B