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

 

 

Regards,

Anders

Outcomes