Recent content by Allyj

Yes i totally agree and I actually enjoy the challenge. It's not too bad as I'm heading into winter and a quieter time to fix it. Appreciate your advice pat. If you don't mind when I think I've got the structure right can I send you the relationship diagram to look at? Cheers Ally

Thanks Mike, appreciate your offer of help I am going to address one issue at a time :)

great advice Pat, consistency is a weakness of mine, it comes with being a creative person I've noticed! But I fully understand your point. thank you :) I like the structure you have explained, I am going to have a go at doing it this way. cheers Allison

Thank you... No I don't think I did fully understand but I think I am starting to get it now. What does PriceDT in your example refer to? I think I would prefer to keep my materials in seperate tables but if you think this adds another layer of complexity, I'm willing to merge them. I've...

Hi Pat, How are you? Yes, you did help me end of last year and to be honest I totally scrapped my badly designed database and rebuilt it again a couple of weeks ago, taking on board some of your original advice on the structure. It works a lot better than previously but as a beginner there are...

Thank you! I sort of understand what you mean now. I am away from my pc at the moment but I will delve into this later and see if I can get my head around it. Many thanks for your time. Allison

Thanks Doc_Man, A couple of questions for you if you don't mind? when you say : The current price is merely price for the metal where the price record's "effective date" is the maximum. Do you mean this is a table that stores multiple records along with their prices and a valid date on the same...

Hi, I am working on a small jewellery business database that I perform quotes on. I update my precious metals price on a regular basis and in most circumstances I only need to use these current values. However, I would like to know a way to store a historic metal price value without it...

Thanks Pat, awesome advice! The image attached is a cast master pattern. We make the original and then they can be cast as many times as required for reproduction work. This is what I am referring to with YS numbers. (Just to help you understand the different categories.) So yes, they are not...

Pat, Firstly, I very much appreciate the time you are taking to help me suss this out. It's very kind of you! I think I will rename the inventory to "Catalogue" as regardless of whether it was a piece we made for our shop stock or a special commission, everything we make can be made in a choice...

You indeed have given me a lot to think about! I really do appreciate you taking the time to have a look at my project. By the way The customer information adresses exist but they are dummy names and emails generated from something similare to what you suggested. 1. Why do you have the...

I will put some dummy customer information in my database and attached it for you guys to have a look shortly. 😊❤️

Yes Pat, this part works fine (the customer Quote report) I would like to then start the Jobsheet report for the jeweller. In ideal world, this would assign a new InventoryID put the estimated weights of the metals (from the quote) and the other job details. Also to avoid the step of finding...

Hi MajP, I hear what you are saying and I apologise for the lengthy thread. I am struggling to work out the relationships. I have tried different ways of going about this and this seemed to most be the most straightforward. I'd be happy for you to take a look, although slightly wincing about...