Hi All!

Can anybody advise me about this:

1. There are 2 tables: A - People, B - Departments
A: PID, DEPID, NAME.....PID - primary key
B: DID, DEPNAME, ..... DID - primary key
A.DEPID -> FK from B.DID

2. Need to edit A in grid with LookupCombo for DEPID.
Grid with columns like: NAME, DEPARTMENT, ...... so DEPARTMENT
column must show B.DEPNAME, LookupCombo must show list of
B.DEPNAME but when I post edits - I need to set A.DEPID with
value from B.DID.

Any ideas?

Thank you in advance.