how to add data ina table as well in anothe table

[mana]

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

 

[Minty]

Sorry your description is not very clear. Can you list your data and where you are trying to save it.

Normally storing the same data twice indicates a poor design unless it is data that can change over time e.g. Parts Price records or similar

 

[mana]

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?

 

[Minty]

What have you tried so far?

 

[mana]

i don't have a clear idea
i don't know exactly what to do
maybe subform but i'm not sure
do you have any ideas?

 

[Minty]

This is pretty basic stuff - you should make a plan of what you are trying to achieve and break it down into small simple tasks.

The simplest route would probably have a command button to copy the data using an append query with the criteria being the current record ID you are on.

Start by creating a select query that pulls the right data in from your form.
Once that is correct you can then change it to an append query to copy it to your other table.

 

[mana]

Hello
Thank you for your help but actually I am working in web access database and it is not possible to write programming things in ms access web
You meAnt prigramming?
Right?

 

[Minty]

I have zero experience of Web Based Access, but I'd be amazed if you couldn't Insert or Append data from a web form. You can from any other Web based application.