I have 3 tables - Clients, Transactions and Prices. A Client can have many Transactions and many Prices.
The Prices table shows each client's individual price for specific transactions (one client may pay 10 for a certain transaction, while another one may pay 14).
When I import transactions from an excel spreadsheet, I have it set up so these will be pulled into each client's Transactions portal.
What I can't wrap my head around now is how to get the transactions to pull in the information regarding prices, so Client A will be charged 10 for Transaction X, while Client B will be charged 14…
I appreciate any suggestions