Results 1 to 3 of 3
  1. #1
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596

    Smile Access 2010 Web Form - Data Entry - One to Many.

    Hi,
    I've used Access for several years - but Access 2010 only recently.
    This is my first time trying to create a Web Form for data entry.
    I have two tables that I want to enter Data into.
    One has the Master record.
    The other one may have 'Many' records for each record in the Master table.
    I'd like to design a form that allows users to enter the master record [which will update the Master table] and then after saving the Master record, allow the user to enter one or more records for the same ID into the 'Many' table.
    I want to do this with as little fuss as possible - making data entry as fluid as possible [do I need to worry about setting focus and tab order & things that I've been used to doing with previous versions of Access? I'm hoping Access 2010 will take care of all that but I'd like to be able to handle that if I NEED to].
    I'd appreciate any help I can get.
    If this has already been explained in a previous thread, please point me in the direction!!
    TIA!!!


    Robeen

  2. #2
    nats.carden is offline Novice
    Windows Vista Access 2010 32bit
    Join Date
    May 2011
    Posts
    1
    Hi,

    Did you have any luck with this? I am also trying to create my first web form for data entry.

    thank you,
    nats

  3. #3
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Hi nats,
    I had to abandon the web form because our organization has not upgraded to Sharepoint Server 2010 and Sharepoint 2007 would not take my web forms.
    I re-worked it with a non-web form.
    I've done several projects since and do not remember the details.
    I believe I WAS able to get the Master Detail thing going but now I do not remember how I did it.
    Sorry!
    I might have a little time in the next two days and I'll try & get it back up & let you know what I find.
    I hope you are not on a tight deadline on this. Let me know if you ARE.
    Robeen

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

Similar Threads

  1. Form for Data Entry
    By cherkey in forum Forms
    Replies: 4
    Last Post: 02-15-2011, 02:40 PM
  2. Replies: 2
    Last Post: 01-15-2011, 10:56 AM
  3. Corrupt Table in Data Set View Access 2010
    By Peter Murray in forum Access
    Replies: 1
    Last Post: 11-29-2010, 04:16 PM
  4. Problems with data entry form Access 2010
    By OfficeQuestions in forum Access
    Replies: 4
    Last Post: 09-23-2010, 01:42 PM
  5. Data entry form
    By adept in forum Forms
    Replies: 1
    Last Post: 08-20-2010, 10:13 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