Customer ID one to many NoteID
NoteID many to one CustomerID
Customer ID one to many WorkorderID
NoteID many to one WorkorderID
NoteID many to NONE workorderID
Basically, I need to be able to reference a workorder if there is one relating to the note I enter. However, their may not be a workorder that the note is referencing. How do I set up this optional relationship in Access 2007?