Results 1 to 11 of 11
  1. #1
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133

    Post I need to make 4 inventories to one factory

    hello everyone
    I have 4 inventories , I buy big rolls for pipe form products , after that I send these big roll for another part at factory to makes it for small rolls , and after that I bring these small rolls for factory to makes for pipes and these pipes sometimes have material damage , it means I should to have 4 inventories .

    How I will make these 4 inventories ?

    1 - big rolls
    2 - small rolls


    3 - pipes
    4 - Material damage
    these are inventories I need to make them
    because I should know How many ( big rolls , small , pipes and damge ) I have in these 4 inventories

    I just buy one times from products and other steps I use at factory
    Who can help me to make them , please ?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    There should be 1 inventory table.
    it holds all parts, part name, type, qty, part num.

    big roll, roll ,6,br1234
    2" pipe, pipe, 3, p234

  3. #3
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    you mean I should make one invoice for buy all things
    for example : When I buy big rolls , I will enter in buyinvoice ( invoice , Date , products name , driver name , car number , amount , expenses , total and notice ) this is for headinvoice
    and for subinvoice (invoiceID , date , products name , big rolls name , small roll name , pipes name , damage name , tons , quantity , price )
    Is it will be same this invoice ?
    But my report for this inventory will be big ,,, because I want to know I bought how many big rolls and How many big rolls I sold and How many now at inventory and for other parts the same .
    because I will have many types of roll ,,, and one big roll maybe I divide to many small rolls .
    and also I should to know how many small rolls I have at inventory ans also other parts .

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you watch this free video to understand relationships. It is critical to get your tables and relationships designed to support your business requirements. You may know what you want, but until you write these down and build an ERD/data model and vet/test/verfiy that model with your defined requirements you are really guessing or designing on the fly. This latter approach is rarely successful.

    Access, or any other software, will not do anything that you have not told it.

    Good luck with your project.

  5. #5
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    thanks a lot for your help
    I think these videos will be useful , but if I didn't understand these videos well , And if I have any question about this topic again I will try to ask you again .

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  7. #7
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    that way helped me , but I have a problem in query , How I will make query When I choose one part automatically those materials go to that inventory ?

  8. #8
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    It would help if you could attach your database, or at least show us your relationships.

  9. #9
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133

    Post

    Factory.zip
    thanks a lot
    but I didn't make Reports and Queries .

  10. #10
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397

  11. #11
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    But there I talked about queries and here I thought We only should write about tables
    because of that , I wrote in there too
    and he asked me about my problem , because of that I wrote to me the same problem in here .

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How do I make a search like this?
    By JohnBlue in forum Access
    Replies: 8
    Last Post: 06-19-2015, 10:15 AM
  2. Replies: 2
    Last Post: 02-17-2015, 01:01 PM
  3. newbie qu: make it here use it there
    By sbrady19 in forum Access
    Replies: 3
    Last Post: 02-12-2015, 09:36 AM
  4. Replies: 4
    Last Post: 02-06-2015, 03:58 AM
  5. Replies: 4
    Last Post: 12-16-2014, 05:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums