Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Null for cust_id?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00188524
Message ID:
00188558
Vues:
17
Allen:

It might be easiest to create a customer record just for this purpose, and anytime a user wants to create a quick sale invoice they assign this dummy record to it. This way, you can track and report on the volume of these types of sales..

Rob
>Hi,
>What is the correct way to save an invoice record when it doesn't have a customer? (ie: a quick cash sale)
>Should I create a customer with no values other than customer_id and save that id in the invoice record, or keep a null value for customer_id in the invoice record? I'm not sure of the pros and cons to using one way over the other.
>TIA for any comments
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform