I want to include a tblDialogue in my database. This would be with a
customer and may or may not be about a specific invoice. I'm assuming
that CustomerID would be a foriegn key in tbl dialogue and so would
InvoiceID.

In the case of the dialogue being about an invoice then clearly both
foriegn keys would have a value. If the dialogue was not about an
invoice can the InvoiceID be a null value?

Is there a better way of approaching this?

On 24/05/2011 22:53:36, BobbyDazzler wrote:
Presumably there will be a subject and a date in the tblDialogue. You can
have a null value key in that linked to the invoice table. So on your
customer form, you select the dialogue by date or subject, presumably from a
combo box, and if the InvoiceID is not null, open the invoice report. Phil