I've been developing for someone, I'm new so it's all free thus it's for experience only. I say that because you'll likely notice lots of errors here that I'm not aware off and boil your blood because someone could be profiting off such tripe!
They're the bulk of my tables, it's all important.
I'm having trouble deciding the relationships. Here's what I think you should know:
A customer can only be an exhibitor, trader, food vendor or weekender.
A customer cannot be more than one of the above.
The aforementioned can only be one registered customer even if they bring x amount of staff.
That tells me it's a simple 1-1 relationship. At first I thought they were 1-n but I'm convinced they should be 1-1. If I create a form I get a lot of errors, although 1-n worked fine when I had that set up (you'll notice multiple IDs).
The reason I've kept customer types separate and not just included a field determining the customer type is because different data is stored depending on the customer type.
So, am I handling this the right way? or do I have my wires crossed?