AnsweredAssumed Answered

Get information from one table when importing to another

Question asked by anders on Feb 6, 2012
Latest reply on Mar 5, 2012 by comment

Hi all,



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