potts
Registered User.
- Local time
- Today, 04:12
- Joined
- Jul 24, 2002
- Messages
- 87
I have created a multi-table form to enter a number of details relating to the use of a facility on a given date. Each individual using the facility belongs to one of many groups. Each group is in effect a customer. As some of the customers receive a discount on the standard access rate, I want to automatically update the discount field in the session form - when an individual is entered into the session - based on the discount value stored in the customer table to which they belong.
Any ideas?
Any ideas?