Eurico Chagas Filho wrote on 2011-10-17: > > > In a restaurant the customer will receive a card to be read by a terminal when ever he orders something. > This card has a established number (1-200). When the client pays, the card can be reused. > At the time of payment the order goes to a database table and all. > > Should I create a free table to hold the order and products ? And then delete and latter zap. > > Or just zero the field w the card number and reuse ? > They may not have a UPS for the server yet. > > TIA, E. >
Eurico, My thought would be to save the data for reporting. Do you allow for split checks? When customer is handed the bill, they ask to split the check. Tracy Pearson PowerChurch Software _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
