I have ask similar to this before.
I have one Table called ACCOUNTS TABLE with DEPOSIT SLIP, CHECK, CHECK REGISTER, AND ACCOUNTS PAYABLE as Layouts.
ACCOUNTS PAYABLE is a compilation of Account Names with corresponding Acct#.
When I write a check, I want to type the ACCT# and have it populate the ACCOUNT NAME from the Layout ACCOUNTS PAYABLE.
I do not remember how to set-up ACCOUNTS PAYABLE to make it possible. I have tried several , cannot get it to work.
Following is a photo of my Relations Graph