Search results

A bit scared to post this. Gentlemen. Wow(!) and thank you for giving of your time. Could I put a meek hand up and, if it’s not been too impolite, ask for some simplicity based on a) my level of knowledge and b) the following word picture of this task and why (‘me’ you can see from my profile...

Dave, thank you. New to Databases, Access & Normalisation (and forums to a degree). What you have posted seems to have blown my first attempts off the screen. It will take this old man some time to assimilate your posted suggestions for I have no ‘picture’ of it in my head at all yet. I have to...

dbDamo, thank you. I believe you were clear, my muddled mind read too quickly and is so again! Couple of hours looking this afternoon before writing this. To move on and review if I may? Any one vehicle/plant which is acquired is the main item we want to know (query) about but queries could be...

Thank you. Yes, the Finance Company can finance many vehicles with many agreements but agreements are per vehicle so the link should go via the Finance Company. Hhmmm. Yes can work this out I think. From my page skipping; Chapter flicking; help text searching something in the back of my mind...

Okay dbDamo and any others. Radical rethink. There is 'Plant' (e.g. Manitu and Lancer Boss) which the business(s) historically lump together in their minds under vehicles so I have decided to include them (bear with me I do think necessary). I have:- Table for Ownership - Look up of Co X; Co Y...

Thank you dbDamo Following your previous suggestions I have done some more work on tables. I haven't got the outcome on this pc to attach the revision with this post. I will tomorrow look again taking into account your above comments (the Model I certainly picked up) and made some other changes...

Thank you both. I'll try to be more expansive to both replies. Three seperate identies; Partnership; Ltd Co. plus vehicle purchases made as personal items by the partners and directors,(Ownership). Vehicles may be bought outright or financed (Aquisition Method) by Hire Purchase; Finace Lease...

Made a valiant attempt and floundered at amending, to our business requirements, the ‘Vehicle maintenance’ template Made the attached Tables to start at building from scratch. The attached shows, I hope, the concept of the information required to store and query. I would be grateful for the...