How are you interacting with your tables? (i.e. forms with text boxes, etc.) If you're doing this in Visual Basic it shouldn't be too bad. Let me know a few more specifics and hopefully we can attack this problem...
Pat
yes, i am using forms to do them. i don't know vb at all, which makes things really hard for me, however i do know sql.
here are my tables:
-
-
Table Name = Products In Stock
-
Field ; Type ; IndexInfo
-
codep ; text ; primary key
-
namep ; text
-
quantstock ; number
-
price ; currency
-
namem ; text ; reference key for manufacturer
-
-
Table Name = Incoming Products (Bought products)
-
Field ; Type ; IndexInfo
-
codec ; text ; primary key with codep
-
codep ; text ; primary key with codec
-
quantity ; number
-
(i designed it in a way that there can be many lines with the same product, since a product can be brought it several times)
-
-
Table Name = Outgoing Products (Sold products)
-
Field ; Type ; IndexInfo
-
codec ; text ; primary key with codep
-
codep ; text ; primary key with codec
-
quantity ; number
-
(here is the same as the second table)
-
what i had in mind was that when the user opens up a certain product in the form for Products In Stock, the forms then searches for Incoming and Outgoing products A and then subtract both their quantities from each other. Thus the user doesn't have to touch the "quantstock", so I was thinking i should probably remove it.
what i can't figure out is how to make the form look automatically for the same product in the other 2 tables.
Thanks for trying to help ^__^