General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for both of your replies. I noticed that the old application that I was using (a purchased app), used no cust_id (null) in the invoice table when a customer wasn't selected. That made me wonder which was the "correct" way. I'll make a dummy customer for this situation. Thanks again
>IMHO, NULL have a tendency to propagate everywhere. I think that a dummy Customer will be more easily managable.
>
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only