Results 1 to 4 of 4
  1. #1
    chuck130 is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    2

    Trouble adding data with forms

    Hello. I am new here and hope this is the right spot to post. I am using a form to add data to a table. What I am wanting to do is be able to add several products, descriptions, and comments to one customer, date, and tracking ID. I tried using a subform, and it works in the form. But when I go to the table the products aren't listed as I had hoped. Instead I have 7 or 8 records with fields missing.



    Any help would be appreciated.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    is this an ordering system? what is your file used for?

    it looks like all you need is one form. I think you might have enough data to split it into multiple tables and form relationships so you can simply your data entry. But to know for sure you may have to tell us what the db is used for exactly. The image suggests an ordering system and tracking ability for customers...

  3. #3
    chuck130 is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    2
    Yes it is. I am using it to enter what is needed and save it to the table so I can keep track of what is ordered and I plan on making a query to look up info based on customer, date, etc.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by chuck130 View Post
    Yes it is. I am using it to enter what is needed and save it to the table so I can keep track of what is ordered and I plan on making a query to look up info based on customer, date, etc.
    I think all you're going to need is a form then that is bound to this table. Make sure it is connect via a customer ID or something else that is primary. be sure to populate that field either with a lookup function in new records or something else. If you do that, the data will most likely be normalized correctly.

    I made a sample once for something similar to what you're doing in terms of the relationships that are needed. I attached it for you.

    if you open the ORDERS form, I think that is doing what you're looking for. the combo populates the cust ID. check out the relationships of how the orders are connected to customers.

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

Similar Threads

  1. Replies: 7
    Last Post: 06-16-2010, 09:19 AM
  2. similar data rows trouble
    By andyf80 in forum Database Design
    Replies: 3
    Last Post: 06-11-2010, 10:06 AM
  3. Replies: 4
    Last Post: 02-01-2010, 05:21 AM
  4. Trouble viewing correct data
    By KevinH in forum Access
    Replies: 11
    Last Post: 07-06-2009, 07:16 PM
  5. Having trouble with dates in my Data Base!!!!
    By BigPhil in forum Queries
    Replies: 4
    Last Post: 02-15-2006, 12:47 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