I have a table (Customers) with a column (taxable) which contains a Yes/No value. I have a report (rptInvoice) with a field (txtTaxable). I want this field to auto-fill based on another field (txtSubtotal) if the Taxable value in the table for the specific customer is Yes. If the table has a No or Null value I want the txtTaxable field to be null. Can this be done?
For example If Customer McDonalds is Taxable and I am printing out an invoice for McDonalds, The txtTaxable field will auto-fill with the txtSubtotal value. ($100 for example)
For example If Customer McDonalds is Taxable and I am printing out an invoice for McDonalds, The txtTaxable field will auto-fill with the txtSubtotal value. ($100 for example)
