How to influence two tables with one form

[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

 

[Bob Quintal]

Hi!

I'm totaly new at access so if could someone could give me an
detailed answer i would me very happy!

You may not like my answer.

I have 3 tables which represent my Warehouse,Store_1 and
Store_2.

You should have 1 table(tblStockMoves), with two fields more
than the existing tables. The fields should be Location_From and
Location_To

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.

Very difficult to do. Very easy with my table design. You just
add a new record, set Location_from = "Warehouse" (0r "W"),
location_to = "store1" (or "1"), the other fields to describe
the item transferred, the date/time/mover/etc.

To get the equivalent of each of your tables, you create a
query, like
SELECT * from tblStockMoves WHERE location_to = "Store_2"

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,

If you must do it this way, you will need to create a form tied
to no tables, just textboxes, and write visual basic code that
makes an insert query for each table. Not a job for someone
totally new at Access, especially since there's a better way.

 

[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

 

[Bob Quintal]

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

you just use the query builder. Reading the help or a book on
Access will explain...

 

[marko]

Did it!
Thanks!