Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Lucy Alice Pilanga
  Where is Lucy Alice Pilanga?
 Metro Manila
 Philippines
 Lucy Alice Pilanga
 To: Manisha Sathe
  Where is Manisha Sathe?
 
 Singapore
 Manisha Sathe
 Tags
Subject: RE: Grid help-want to know good way of doing it
Thread ID: 33789 Message ID: 33829 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Grids
Date: Thursday, December 04, 2003 3:59:09 AM         
   


> When i want to add into child, i want to take up from another table (which has item and balance qty) - what i want is when i click on add for child - it displaysa grid with item and balance qty, i can select one reord. After selection this will appear in a form's child grid. Then i can change only qty inside child grid, after submit balance qty is updated. Also I do not want user to select same item twice also can not enter qty greater than balance qty.

in the valid or lostfocus of the grid's textbox (quantity field), right away check

if quantity_ordered > available_balance_qty
&&message quantity exceeds the available
endif

and just after selection of another new item ( but...which already exists in the order list), loop thru the grid to check for the item id. if exists, then a form with textbox quantity should appear asking for the additional quantity for the existing item. then add it to the value in the grid of existing item.


-Lucy Alice

ENTIRE THREAD

Grid help-want to know good way of doing it Posted by Manisha Sathe @ 12/3/2003 5:16:25 PM
RE: Grid help-want to know good way of doing it Posted by Jamie Osborn @ 12/4/2003 12:44:22 AM
RE: Grid help-want to know good way of doing it Posted by James Stewart @ 12/4/2003 3:06:10 AM
RE: Grid help-want to know good way of doing it Posted by Manisha Sathe @ 12/4/2003 2:28:27 PM
RE: Grid help-want to know good way of doing it Posted by lucy alice pilanga @ 12/4/2003 3:59:09 AM