Hiya I’ll post some tomorrow when I am back at work, I don't have any related tables.
That's a good idea. All you need post is the form or forms relevant to your problem and tables relevant to your problem.
If I can see your form(s) and your table(s) it makes it easier for me to analyse your question and formulate a response.
If you (and I'm not referring to you personally I'm referring to anyone that asks a question) don't post anything, then that means I will need to create something to help me guess what the problem is.
I have several sample databases which I can quickly fire up to test different scenarios. But this means there's a high probability I will miss the essence of the problem.
If I do solve the problem and present you with a sample database, then you will have to convert everything in the sample to suit your database.
However if I start out with your database, it's going to be easier for you to implement the solution.
When I say "your database" I mean a mockup of your problem in the simplest form possible with the least amount of forms and the least amount of tables, and data in the tables.
If you provide a sample database I can fire up and inspect, then it's much more likely that I will do that. If I need to create a sample database myself then I might not have the time, and I will skip the question, finding one that is quicker and easier to answer.
My guess is most other people here are the same, too busy to get deeply involved in a complicated question, they will pick off the simple ones first.