HillTJ
To train a dog, first know more than the dog..
- Local time
- Today, 05:32
- Joined
- Apr 1, 2019
- Messages
- 731
Hi, seems simple but i am building a quoting database that has a reference price in a field, but i need to have the ability to save the actual price i enter which may be different to the reference price. I set the default = to the reference but obviously every time i pass through the record it reverts to the reference price. I guess i need an if statement to see whether the actual price field is null, then if it is then copy over the reference value. It could then be edited to achieve the price i need. Apreciate any assistance.