Results 1 to 3 of 3
  1. #1
    Join Date
    May 2012
    Posts
    132

    Unanswered: multy data entery

    On a form there are some comboboxes and textboxes. They receive their data from other tables. For example table1 and table2.


    I would like to push the record button and insert the data from combobox1 in to table3, Textbox1 to table4 and textbox2 into both table3 and table4. How can I design this action?

  2. #2
    Join Date
    Oct 2006
    Posts
    110
    You'll probably need to explain further why you want to do this. If you've got the data already, why would you want to duplicate it in other tables?

  3. #3
    Join Date
    May 2012
    Posts
    132
    There are two tables: Expenses and Sales. They keep record of expense and sales amounts by employees. It is supposed that “incomes” and “expenses” are recorded on the same date. One single form is to input data to both tables. As a result, “ date” and “employeeID” are recorded to both tables, however expense and sales amount are recorded only in the respective tables. I hope this design makes sense and it is not duplicating data.
    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •