cash sales vs invoices

[Dynamite]

I'm creating a database where I have a customers and invoices table, obviously there is a relationship between the two tables using a customerID field where I have referential integrity enabled. However not all invoices require a customer account as some are cash sales where no customer details are required.

I'm unsure of the correct procedure, all I can think of is to create a separate table for cash sales??

 

[boblarson]

I had a similar situation and I just created a Cash Sale customer to select for a cash sale.

 

[neileg]

Bob's suggestion is the one I have most often encountered in my day job as an accountant.

 

[GaryPanic]

Bobs suggestion was the one I was going to recommend

I used to do the same thing