So that everyone can see what we're talking about
:
1) If you click on one of those triple links and try to edit you'll see that they open in the same relationship dialog. By doing this I'm treating them as a compound primary key in tbl_authorizedloanclass and as Foreign key in tbl_loanaccounts.
>>>EDIT>>> And in fact the three fields in are part of a compound index in tbl_authorizedloanclass set to unique but not primary - thus you can not have two records using the exact same apprasier, county, and loan type<<<Edit<<<
The Extra "pk_*" in each is a bad habit I have... compound keys are good for this but a pain in VBA (i know... breaks a zillion rules) Thus you get the required "related record."
2)Well, my thought is the top section is for reviewing the created accounts with a limited means of editing. I would think that one would not want the user easily modifying accounts once assigned to an appraiser.
I could attempt the cascading effect there; however, I've occationally had issues with bound controls when I've done so in the past.
The bottom section.... because I liked it ;-P
and it allowed the new record creation to be always available while avoiding the issues I've ran into with bound controls when attempting the same affect.