I need help with Microsoft Access. I have a database of clients which includes:
1. Client
1.1 Bank account of Client Nr 1. (EUR)
1.2 Bank account of Client Nr 2. (USD)
Then I have a fillable list, where I choose Client and Currency. I need the bank account fill automatically with the one which corresponds to the correct currency. So I need Bank account info be connected to both, Client and Currency.
How do I do that?
Up.