How many Thursdays in current month

[Micron]

The one thing that still bothers me is the linking fields (PK/FK). It is not recommended to have text PK/FK fields.
Having a text field "Cuscode" as the linking field is bad because if you someday want to change the customer code naming scheme, you will have to change the linking fields also. Difficult at best.

Basically agree. While not impossible to deal with, it can be more hassle than it's worth. The only time I've seen this work with any degree of success is where alphanumeric dept codes were used as a PK field and the answer to what to do when a dept got a new name was to obsolete the old and continue on with the new. Personally I would avoid it if possible.

Anyway, glad you got it solved. Too bad you didn't comment on moving the code to the form Current event, as I think that's what you'll end up doing.

[tbjmobile@gmail.com]

I appreciate your comments both. I will keep it in mind for if and when I get the thing finished and clean up some of the many things that need tidying. We have used this code system for about 22 years !