Recent content by GeordieH

  1. GeordieH

    Solved Work order System with a few extra bits thrown in

    I get the point you make about controlling the user input, i'll get to that soon enough. Once I've got the system developed, I can repost it for you, but that's going to take a little while yet. I think I want to be confident I have a solid structure that i can test and run some examples, I'll...
  2. GeordieH

    Hello everyone!

    Welcome Florin, I've just joined the group as well. Its been very helpful :)
  3. GeordieH

    Solved Work order System with a few extra bits thrown in

    Hope ive marked the thread ok with the thumbs up
  4. GeordieH

    Solved Work order System with a few extra bits thrown in

    Hi Minty, Heres the finished structure with some data thrown in to make it sensicle. Cant thank you enough, ive been going round on this for weeks, not being able to link or understand how to link tables in the way you described. Thanks for the learning curve, much appreciated.
  5. GeordieH

    Solved Work order System with a few extra bits thrown in

    Hi Minty, That's great, it pulls the RA through linking it to the WO Task (y) I'll get into changing the status so it shows the info later I tried that on the PPE, created a form from the WOPPE Table (y) But when it comes to linking it to the table it offers up the Vehicle ID ??? So how do...
  6. GeordieH

    Solved Work order System with a few extra bits thrown in

    Hi Minty, Remember that each WO Task will have many RAs, PPE & Equipment :) :) That's the bit a cant pull through :)
  7. GeordieH

    Solved Work order System with a few extra bits thrown in

    Have a look at this, I hope ive explained it ok. open the FrmJC, theres a note on there to read to try and explain where I want this to go.
  8. GeordieH

    Solved Work order System with a few extra bits thrown in

    Worked on this project last night. I created a query to incorporate the Vehicle to the WO Task, that worked fine and created an input form to present it. Its a standard layout I use to gain a hierarchy. Then I created a query to link Vehicle to RA and the query worked, that is it populated the...
  9. GeordieH

    Solved Work order System with a few extra bits thrown in

    Hi Minty, I've added the extra tables and its working to a degree. I think its going to be a combination of getting the Qry right and then turning them into a form. Let me work on it and i'll come back to you tomorrow if that's ok, don't know if you're about!? Thanks for all the help today...
  10. GeordieH

    Saying Hello to the group

    Hi Everyone, Such a response, brilliant. other groups ive been in are MS Access orientated, but they're drop in groups, people only sign in for quick answers then zip out. There was one I was involved in and spoke to a guy in Canada, very helpful and we swapped a few ideas on a number of...
  11. GeordieH

    Solved Work order System with a few extra bits thrown in

    Hi Minty, I'm sure a junction table is needed, but no matter which variation i put in, it fails. Rather than use a lookup, because there are numerous (100+) RAs and Equipment to chose from, I would rather use a table which we can look up but make multiple selections from that table and attach...
  12. GeordieH

    Saying Hello to the group

    Hi, Hope you're good :)
  13. GeordieH

    Saying Hello to the group

    Hi Guy, hope you're good :)
  14. GeordieH

    Saying Hello to the group

    Hi Minty, Keeping fresh :) Thanks for the invite, much appreciated :)
Top Bottom