How to insert into two tables at the same time

[mana]

Hello,

Do you know how I can insert into two tables at the same time?

 

[CJ_London]

you can't - you need to do two separate inserts

 

[mana]

hi

but it is possible with named data macros and i tested it
but it doesn't work and i don't know where my problem is
i also attached the picture that i made

 

[jdraw]

CJ has given you the answer.

If, as you say,

but it is possible with named data macros and i tested it

Please show us the details. And if you have tested it, please show the test.

 

[CJ_London]

I don't use data macros so regret I cannot advise.

This link may help

https://support.office.com/en-nz/article/Create-a-data-macro-b1b94bca-4f17-47ad-a66d-f296ef834200

according to this link, named data macros can be associated with a single table - and you want to associate it with two. So I suspect that is why you can't get it to work.

 

[mana]

the picture is the design of my data macro
but it doesn't work and i have the error message:
inset in item (the name of my table) is not possible

 

[mana]

i have also another problem
i want that one of my fields will be inserted a s below to my table

is epm_info (name of my field in my tabel) is implemented

i tried it with calculated columns but it didn't work
do you have ideas how to do this?
thank you

 

[CJ_London]

As explained before, I don't use macros so cannot help - however the link I provided includes a section on debugging macros. I suggest you read that to get a better understanding of what your macro is (or is not) doing.

 

[mana]

hello

but about this part do you have ideas how to do this?
it is a normal caocat in ms access
i don't know how to do this?
thank you

is epm_info (name of my field in my tabel=id) is implemented


i want this sentence to be saved to one of my other fields
this new field is question=is epm_info 2=id is implemented

 

[jdraw]

@mana,

It might be helpful to readers if you could give a description of what you are trying to accomplish in simple English (no Access jargon), and an example of starting info/data and then final info/data.

I don't use macros either. But macros, vba etc are HOW you do something. We want to know WHAT you are trying to do, then you'll get options for HOW.

 

[CJ_London]

but about this part do you have ideas how to do this?

Unfortunately, I don't

Your original post was about inserting into two tables at the same time
- which I answered - but had not noticed your question was in the access web part of the forum.

you then moved to named data macros, something I know nothing about, but I took the time to research and provided you with a link - which you have not acknowledged so I have no idea if that was helpful for you or not

and then you moved to something else

Since we are now in completely different territory from your original post, I suggest you start a new thread in the macro section and include the words 'data macro' in your thread title

good luck with your project