10 Replies Latest reply on Mar 5, 2012 9:47 AM by comment

    Get information from one table when importing to another


      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