AnsweredAssumed Answered

Auto-enter based on an indicator field

Question asked by henry369 on Jul 24, 2015
Latest reply on Jul 25, 2015 by henry369

Title

Auto-enter based on an indicator field

Post

I am trying to figure out how to auto-enter into a field, one of several options of  values, from a related table, based on an indicator field in the destination table.   Specifically, a product has different pricings, depending on who the buyer is.  So there is a retail price, a government price, and a non profit price.   The source table is "pricing" with 4 fields.  The product code (key field) and the 3 pricing fields for each of the different buyers.   The destination table is an invoice, with the product code field, an indicator field which is a value list of the 3 different pricing categories (govt, retail, and non profit) and the price field.    When, say,  the govt indicator is selected in the indicator field, for the specific product code, I would like to have the govt pricing appear in the price field in the destination table.  I am wondering what is the best way to accomplish this.  Any help would be greatly appreciated.  Henry

 

 

Outcomes