Thank you for your post.
The Relationship between Accounts and SubAccount is based on "Account Number".
The Relationship between SubAccount and Transactions is based on "SubAccount Number"
In the Transactions table, set the Options for "Account Number" to be a Lookup into the SubAccount table, returning the Account Number. Then, when you enter a SubAccount number, the Account Number will automatically be populated.