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