Creating delivery note in access

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Sandretto
    New Member
    • Jul 2010
    • 16

    #1

    Creating delivery note in access

    Hi

    At the moment we currently hand write our delivery notes, was wondering if it possible to let access write them? Currently have tables -
    tblOrders (this is where order info is stored and works no is assigned)
    tblDeliveries (Contains qty delivered, how it delivered)
    tblproducts-(contains all product info)
    tblCustomer- (Contains all customer info)

    I've tried creating a form but i can't get the information to store in deliveried table. Any suggestions?? Thanks in advance! Attached print screen of my relationships
  • Delerna
    Recognized Expert Top Contributor
    • Jan 2008
    • 1134

    #2
    There are several ways you can do it but you do not have any where enough info in your post for me to give an answer.

    Best piece of advise I can give you is
    Break the task down into the series of steps required to achieve your goal.

    If you don't know how to achieve any of those steps then ask about them here.... one per post. Your question as it is is probably a little too "all encompasing" to answer in a forum.

    Comment

    • doma23
      New Member
      • May 2010
      • 107

      #3
      How are you trying to save the data from the form?
      Are you using bound or unbound form?
      Are you using a memo field in your tblDeliveries, for delivery notes?

      Comment

      Working...