Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Create MultipleItem Form with common information

    I have just started using Access for my business so your help will be greatly appreciated. I am working on tracking my inventory and I would like an easy way to add inventory from my purchase receipts. I would like to be able to enter common information like date, supplier, and receipt number once while being able to add individual information each item purchased such as description, cost and category. I can do it from a multiple item form but I have to enter the supplier for each record. I am sure there is a way but I can't seem to find it.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    Are you familiar with Normalization?
    You may get some ideas from this free tutorial.

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

Similar Threads

  1. Replies: 7
    Last Post: 03-08-2013, 03:58 PM
  2. Replies: 1
    Last Post: 12-18-2012, 02:50 PM
  3. Replies: 2
    Last Post: 12-16-2012, 02:48 PM
  4. Replies: 2
    Last Post: 12-14-2012, 04:08 PM
  5. Merging information to create ID field.
    By Raga32 in forum Forms
    Replies: 3
    Last Post: 08-08-2011, 03:09 PM

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