How to insert some parts of a form to a table

mana

Registered User.
Local time
Today, 07:35
Joined
Nov 4, 2014
Messages
265
hello

i have a form in ms access and it contains some columns from another table.
i want that when i insert the data in this form the data will be inserted automatically in another tbale as well.
do you know how it is possible
i didn't add the columns from another table but actually these columns exist in another table
do you have any ideas?
thank you
 
you know:

i have two tables:
checkpoint and epminfo. epminfo includes some columns of checkpoints table and when i want to insert the data into epm i want that the related columns to checkpoint also will be added to this table. do you have any ideas? how can i do this?
 
I don't understand your situation. Can you show readers your table designs? Screen captures of table designs, then post.
It would help if you could describe what your database is about to help with context.
 
hello,

untitled and untitled 1 are design of checkpoints table

then the other three pics are for EPM info table. actually the columns of checkpoints table are also existed in epm infos table as well.
i want that when i insert the data in emp info form the data will be inserted in checkpoints as well
do you have ideas?
my database have some tables for inserting some documnts, some information(checkpoints), some reports, inserting some epm information.
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    93.6 KB · Views: 212
  • Untitled2.jpg
    Untitled2.jpg
    87.3 KB · Views: 226
  • Untitled3.jpg
    Untitled3.jpg
    86.6 KB · Views: 226
  • Untitled4.jpg
    Untitled4.jpg
    81.2 KB · Views: 214
  • Untitled1.jpg
    Untitled1.jpg
    94.8 KB · Views: 227

Users who are viewing this thread

Back
Top Bottom