User Profile

Collapse

Profile Sidebar

Collapse
Matrouz
Matrouz
Last Activity: Jun 27 '15, 05:11 PM
Joined: Apr 10 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Matrouz
    started a topic Subtracting sold items from stock (MS Access)
    in Access

    Subtracting sold items from stock (MS Access)

    I'm making a fairly simple database to track inventory and make invoices.

    When placing a new order i would like the system to automatically subtract the sold items from the quantity in stock, please bare with me because even though i have some experience but i am still learning.

    Thank you for your help.
    [IMGNOTHUMB]http://bytes.com/attachments/attachment/8344d1433186941/1.jpg[/IMGNOTHUMB][IMGNOTHUMB]http://bytes.c...
    See more | Go to post
    Last edited by NeoPa; Jun 1 '15, 09:13 PM. Reason: Updated to show images
    • Matrouz
      replied to Help needed in an order form in MS Access
      in Access
      Thank you for your response, Ok i have corrected my tables and removed duplicate data, now i need someway to pull up the item info like Price and Volume into my New order form, then into an invoice, can that be done with a query/report or there is a better way of doing it ?
      See more | Go to post

        Leave a comment:

      • Matrouz
        started a topic Help needed in an order form in MS Access
        in Access

        Help needed in an order form in MS Access

        I needed to create a database for my business, I’m almost done but I’m facing a problem in my 'New Order' form,
        I'm using MS Access 2013, on windows 7.
        I have created the following tables:

        Products: (ID{PK}, Item, Volume, Quantity, Price)

        Customers: (CustomerID{PK} ,Name , Phone, address, etc.)

        Order: (OrderID{PK}, CustomerID{FK}, date)

        OrderDetails: (OrderID{FK}, Item,...
        See more | Go to post
        No activity results to display
        Show More
        Working...