Search results

That's exactly right, thank you. As for the dates, all I really need at this stage is a system capable of producing reports listing which equipment was used on a specific job- regardless of the reality that equipment may spend 2 days on a job that spans 2 weeks. I may look to include this...

can kit be assigned to more than one job and/or person at the same time? Equipment can be assigned to more than one job at a time. I'm confident this is how I want it to work, as the end goal of the system is to create reports detailing what equipment was used on particular jobs. To check...

Happy to elaborate, feel free to ask anything that will help you understand what I am trying to achieve. Yes, equipment can be assigned to a job without being assigned to staff. I had hoped to create a table (tblStaffKit) and basically "group" several items of equipment under one field...

Hi CJ, thanks for the reply. Please check the original post, a link to a screenshot of my tables and relationships was included, I replaced "."s with the word "DOT" to allow me to post a URL.

Hello! I am creating an Access Database for work and through this forum, google and brief exposure to MS Access in college 7 years ago, I have managed to throw something together that I am reasonably happy with. I have now reached a stage where I could use some advice from more experienced...