Going through lesson 1. I have copied the DiscountRate field over from the CustomerF to OrderF as you did in your example. I set the default value as you did also. However, the discount rate only carries over for some of the customers, but not all. When clicking on You 40%, Ronald Simms 40% or Alan Watson 7% the discount rate is not carrying over to the OrderF. It is for all the others. I even deleted the fields, compacted/repaired closed and reopened, copied back over and still does not work.
Keith StantonOP
@Reply 5 years ago
Never mind It appears I had a couple of blank orders. That made it look like it wasn't defaulting to current discount percentage.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 9.