How to influence two tables with one form

M

marko

Hi!

I'm totaly new at access so if could someone could give me an detailed
answer i would me very happy! :)
I have 3 tables which represent my Warehouse,Store_1 and Store_2. Now i
would like to have a form in which i would write things which are going
from the warehouse to the stores or from the stores to the warehouse.
So at the same time
in the Warehouse table I would have a record(s) containing a -(minus)
sign and in the store record(s) containing a + sign. My problem is how
can one form fill out two tables at the same time. In one table write a
(+) sign on transactions and in one a (-) sign on that same field. How
can i do this?
Thanks,

Marko
 
M

marko

Thanks for your answer but i don't understand it 100% percent. I don't
understand how to make that query, will you please explaint it to me a
little more detailed?
Thanks,

Marko
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer data between two tables 3
How to have two tables on same line? 1
Adding data to MS Access from csv file 0
Two lines in one in one line - How to do 2
Two record pointers to same table with DAO recordset 2
Add additional information to excel form after original data entry 0
How to disable Alt+s in Outlook 365 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top