Heya Hugo,

Yes the requirement does include have some control over the keywords/tags used and provide a list for user to select from so I will be including a keyword source.

Thanks

Steve

Thanks to you too Hugo for the interesting and informative discussion. I think what this discussion really needs is a few napkins over a drink or two, at least from...

Thanks Hugo, I did have something similar however the challenge I came across was linking the Department-Team-Role combination to the Services table and other tables that need to link a...

Hi Hugo,

A Role can be a member...

Hi Hugo,

Thought I would just let you know what I finally decided, also in case anyone else is interested. I don't think you'll like it. However since I am...

Hi Hugo,

Thank again, I will take all you say onboard as I agree 100% with everything.

I should mention that the text that follows doesn't really have anything to do...

Hi Hugo,

Sorry to bother you, hopefully one last time. I have attached simplified erd, Is this the structure you were eluding too?

Recapping:

- Departments can have member teams

- Departments can have...

Thanks Hugo,

Looks like a trip back to the drawing board

Take Care,

Steve

Thanks Hugo and Tom for your very detailed and informative responses. I think where I am going wrong in my thinking is in trying to deal with a front end...

Gentlemen, thanks very much for your time and input.

Hugo, I am glad to hear that the bit column for one record is a valid design decision. As for what NULL...

Hello Hugo,

Thanks very much for your input, I will see what I can do regarding the design.

Also thanks for your code example, don't know why I was thinking of pivot,...

Thank to you both for the quick reply.

Didn't realise I needed to use a CASE as the values I was are (0 or 1) so assumed that would work.

Thanks again

Thanks Gianluca!

Thant was spot on, worked a treat