rmsherman Posted March 23, 2002 Posted March 23, 2002 I have developed a Budget File and a Requisition File. I would like to link the two in such a way that (1) a message would pop up if someone is requesting supplies from a budget line item that does not have the funds to cover that purchase, or (2) better yet stop the user from continuing with the request, that is, prevent the new record of that request from being completed? This is to become one part of a larger purchase order program. Thanks.
Fitch Posted March 24, 2002 Posted March 24, 2002 Tight control over creation of new records is typically handled with a layout for data entry where all the fields are global fields. A user can enter all the data, but nothing is "posted" until a button is clicked / a script is run. In your scenario, the script would first check the budget, and if ok, a new record would be created and the data fields would be set to their corresponding global fields (and you'll probably want to empty all the globals afterwards). The way the script checks the budget would simply be something like: If (gAmount > BudgetLineItem::Amount) . Show Message ("No way, Jos
Recommended Posts
This topic is 8267 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now