That is a great summary of what I'm doing. Thanks Dave.
BTW I have a copy of "DAO Object Model" by Helen Feddema, I noticed a photo of your copy in a thread from last year. I'm coming back to Access after a long (8 year) absence and have started reading it again. That is why I'm very rusty...
Thanks for the message!
I'm still getting these spam messages and I'm unable to complete posts to the thread I am on. By the way, what is a PM? Is it Personal Message?
It seems that I can post to this thread without the administrator message preventing me.
I'm trying to make a post but I keep getting messages that my post is spam-like and I need to contact an administrator.
I don't know where to look. I've attached a copy of my post, which seems OK to me, but I can't make a reply. How do I find an administrator?
Thanks for the replies with lots of great ideas.
I certainly have enough to solve my dilemna now.
Thanks all
This will also help with another query I'm yet to do. This will have many more duplicates and possibly triplicates. These horses have Trait Y.
So I could make some smaller tables using...