I am working on a reporting system for an automated liquor dispensing unit for a nightclub...
I need to create records for a table based on an event and a bar being used. The user first picks
an event from a dropdown list combo, then the bar from a dropdown list combo. Once these items
are selected, the program needs to search the TALLY table for records that match the event.eventid
(stored in tally.eventid), and bar.number (stored in tally.barnum). If records to NOT exist, then records
will be added to the TALLY table (one record each from another table called inventory). Finally
only records associated with this event/bar are to be displayed in a grid to allow the user to update
two fields per record... startqty and endqty.
I believe the best way to check for the existance for records is to perform a select or seek SQL of
some sort and checking to see if I have a match. If not, I then perform some sort of routine to append
records to TALLY based off the inventory table - 1 record each.
Second, how do I get the grid to ONLY show the records I have found that match the event/bar and
then when changes are made, effect only those records in TALLY?
Thanks
Peter Brama
West Pointe Enterprises
VFP is getting easier but STILL alot to learn!!