Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    How can i add data from one text box into two fields of two tables?

    hello.

    I have two related tables WORKER with worker_ID field as primary key, and WORKERInfo whitch also has worker_ID field. I have created simple Data entry form based on thees two tables, but now i need enter worker_ID data twice (into two text boxes): once for table WORKER and once for table WORKERInfo. How can i add data from one text box into two fields of two tables?

    thanks for your attention.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So the relationship of the two tables is 1:1? If so then why do you have two tables?

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

Similar Threads

  1. fields of type text
    By ashiers in forum Forms
    Replies: 0
    Last Post: 11-28-2008, 10:52 AM
  2. Query to Display Tables & Fields
    By foxerator in forum Queries
    Replies: 0
    Last Post: 04-24-2008, 09:57 AM
  3. Split text field into two text fields
    By Grant in forum Access
    Replies: 6
    Last Post: 01-31-2008, 05:52 AM
  4. Replies: 1
    Last Post: 06-03-2006, 05:02 PM
  5. Concatenate two fields (text & number) for key field
    By Larry Elfenbein in forum Forms
    Replies: 2
    Last Post: 11-10-2005, 07:45 AM

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