Search results

  1. C

    Help Please! Database Design - Relationships

    Hi, I have sent my e-mail address to you in a private e-mail. Thank you for your help. I will give feedback when I receive it. Cheers
  2. C

    Help Please! Database Design - Relationships

    Hi fredp613, Sorry for the late reply but I was away for a while and now struggling to get back to this database thing. I think what you propose is something that might work for me. Is it still possible to send me a sample? Because after all this reading and working I have realized that I need...
  3. C

    Help Please! Database Design - Relationships

    Thank you Kryst51, Much appreciated, but there is no need to work on the 2nd option because 1 factory sheet can only have 1 item - this is a rule. I am going to look into the attached file, but due to my visits of the sites next week, I might not be able to give feedback. Thanks a lot, again...
  4. C

    Help Please! Database Design - Relationships

    ha ha :) i have two fours :P sorry for that...
  5. C

    Help Please! Database Design - Relationships

    Sorry for late reply, 1- Ladies, men, kids, t-shirt... these are not related to my database, I just wanted to make it easier to visualize what my business deals with. Only important element is the item name, the others are just examples. Substrate = the paper we print the tag on. GSM = the...
  6. C

    Help Please! Database Design - Relationships

    Item is connected o an RBO normally. because every item is a product of that particular RBO. But, in my database I wanted to connect the RBOs to the item, because from production point of view, RBO is just a reporting function but item itself is the key element. But as long as every factory...
  7. C

    Help Please! Database Design - Relationships

    Oh good to hear that, I have started to think if I made things more complicated with that workflow after I sent it :P Actually, my cells are in different places, and I am receiving their reports separately. I am planning to put the database in each cell, and treat them as separate factories...
  8. C

    Help Please! Database Design - Relationships

    Also the purpose of this database is: 1- Keep track of the jobs in my production area 2- Get weekly scorecards generated automatically (currently I am filling them via pivot tables, and copy paste data) Scorecard needs the following info for each day: 1- how many production jobs come in (also...
  9. C

    Help Please! Database Design - Relationships

    Ok, I think I understand what you mean, the problem is partly me maybe, because I am working with this process everyday and expect everybody to be familiar with it :) Well, in the attached file I tried to make a workflow as detailed as possible. Hope this would be helpful. (yes i love colorful...
  10. C

    Help Please! Database Design - Relationships

    I would love to be able to do it myself but unfortunately this is where I stuck :) I would be really grateful if you can show me how to overcome this on the file. And I think showing it on the actual file would be far more descriptive for me too, than telling it. I am a visual learner too...
  11. C

    Help Please! Database Design - Relationships

    Yes, I have no control over the factory sheets, all the info in them are already entered by the other departments. When we receive them, my team enters them to an excel spreadsheet to keep track of the jobs. And at the end of the week and month I try to extract reports. As I have said earlier, I...
  12. C

    Help Please! Database Design - Relationships

    Oops, sorry for that, please find the 2003 version attached.
  13. C

    Help Please! Database Design - Relationships

    :) oh yes saturday... weekend... hmm i think i should take a page out of your book and do something funnier than working on databases :P cheers :)
  14. C

    Help Please! Database Design - Relationships

    Hi Kryst51, Sorry for the delay, I had a very tiresome flight yesterday and finally got some time to look at this database. Well, please find the new version attached below, I have made some changes as you suggested, and it seems much better :) I have couple of questions ( some of them might...
  15. C

    Help Please! Database Design - Relationships

    Hi MaZeWorX, I have played around with combo boxes for a while, but I think I am not there yet. I am trying to sort my tables out before getting into the forms, because whenever I try to make a form to enter an order with multiple factory sheets I get some errors. But, as you have said, I have...
  16. C

    Help Please! Database Design - Relationships

    And one more thing, I have put the "order type" and "job type" at the OrderID table, because this was the way that I was entering jobs, I see it now that I am still thinking the way that I receive the factory sheets and enter them into the job list. Because as I said 1 order can have multiple...
  17. C

    Help Please! Database Design - Relationships

    No, please I am more than happy to hear some recommendations, I was unable to send the database because I am currently traveling and I have my macbook with me, and the database was in my pc at office, but I have asked my colleague to send it to me, then I will post it asap. As for your...
  18. C

    Help Please! Database Design - Relationships

    Hi, I am just a beginner in access (actually I have started this whole thing when people made me crazy by corrupting my neat excel sheets and messing up formulas). I must confess that I was thinking it would be easier but I knew nothing then, now I am totally aware that this stuff need real...
Back
Top Bottom