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

    Get information from one table when importing to another

    anders

      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

       

       

      Regards,

      Anders