Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to many forms
Message
 
To
04/08/1997 07:29:49
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00043022
Message ID:
00043045
Views:
34
We use rules and triggers to do most validations.
U can also use beforerowcolchange event and afterrowcolchange
event in grid to do validations.

let me know if u need more help.

ajay



>Can anyone tell me what is best the solution to validate data in one one-to-many-form?
>
>The relationship is defined in the environment.
>
>Parent Table: Expense (docnumber, ... etc)
>Child Table: Item (docnumber, duedate, value, accountnumber)
>
>To each item I have to check if the due date is valid, the value is not zero and to update another table (month balance). Month balance table contains one record to each account/year/month.
>
>My problem is to choose the best method to do the data validation in the item table (contained in one grid) and the update in the month balance table.
>
>Does anyone have one form class to forms one-to-many or one sample with data validation in grids?
Ajay Sanghani
WinSmart Solutions
Building Software Better and Faster
WebSite : http://www.winsmart.com
Email : ajay@winsmart.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform