Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null for cust_id?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00188524
Message ID:
00188558
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform