posted again, Please help

[MD]

hi,

I am developing this application for our shop to track
materials in/out the shop. i have a tbl and form for
materials in (tblProducts, frmProducts)and a tbl and a
form for materials out (tblTransaction and
frmTransaction), each product has a unique product ID
which will be same for both tbls and a job number feild,
the jonnumber for materials in is always the shop job
number 8645 and never changes but in tblTransaction it
will be different from transaction to Transaction. I also
need to deduct what goes out from what comes in the shop
to refelect the current status of specific item. I have
been able to do this dedeuction using a different table,
a query and a subform on the frmTransaction but it
doesn't change the value of the UnitsInStock after the
Transaction was made.

Please help put some light into my path by helping me on
ways to define the relationship between theses two three
tables and ways to have the value of the UnitsInstock
replaced after a transaction is made.

Your help is greatly appreciated.

Regards,

MD

 

[John Vinson]

Masood,

This is a peer-support newsgroup, not a chat room. Impatiently
reposting your question less than an hour after posting it is simply
unreasonable.

Check the previous post for an answer. And please have a little bit of
patience with the unpaid volunteers who reply to the messages here. If
that's not satisfactory, I'll be glad to refund the fee you paid to
ask: here - <>

 

[StCyrM]

Bravo John...my sentiments exactly.

Maurice

 

[MD]

I'm sorry for it appearing like that, My original posting
was made last week and I really don't know about any
posting after my second one, it must have happend un-
intensionaly.

-MD

-----Original Message-----

 

[John Vinson]

I'm sorry for it appearing like that, My original posting
was made last week and I really don't know about any
posting after my second one, it must have happend un-
intensionaly.

-MD

Your first message, with headers:
Content-Class: urn:content-classes:message
From: "MD" <[email protected]>
Sender: "MD" <[email protected]>
Subject: need help please, tbls Relationship
Date: Wed, 17 Sep 2003 19:40:58 -0700
Lines: 29
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcN9jkqJDQR6SJ94Ty2iWRs8A432yA==
Newsgroups: microsoft.public.access.forms
NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
Path: nntp.widaho.net!TK2MSFTNGP08.phx.gbl!cpmsftngxa06.phx.gbl
Xref: emerald-hp microsoft.public.access.forms:197461

hi,

I am developing this application for our shop to track
materials in/out the shop. i have a tbl and form for
materials in (tblProducts, frmProducts)and a tbl and a
form for materials out (tblTransaction and
frmTransaction), each product has a unique product ID
which will be same for both tbls and a job number feild,
the jonnumber for materials in is always the shop job
number 8645 and never changes but in tblTransaction it
will be different from transaction to Transaction. I also
need to deduct what goes out from what comes in the shop
to refelect the current status of specific item. I have
been able to do this dedeuction using a different table,
a query and a subform on the frmTransaction but it
doesn't change the value of the UnitsInStock after the
Transaction was made.

Please help put some light into my path by helping me on
ways to define the relationship between theses two three
tables and ways to have the value of the UnitsInstock
replaced after a transaction is made.

Your help is greatly appreciated.

Regards,

MD

And the next message:

Content-Class: urn:content-classes:message
From: "MD" <[email protected]>
Sender: "MD" <[email protected]>
Subject: posted again, Please help
Date: Wed, 17 Sep 2003 21:35:57 -0700
Lines: 29
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Thread-Index: AcN9nlrEqtxCvGRkRoC9m0ngamtLyQ==
Newsgroups: microsoft.public.access.forms
NNTP-Posting-Host: TK2MSFTNGXA14 10.40.1.166
Path: nntp.widaho.net!TK2MSFTNGP08.phx.gbl!cpmsftngxa06.phx.gbl
Xref: emerald-hp microsoft.public.access.forms:197471

hi,

I am developing this application for our shop to track
materials in/out the shop. i have a tbl and form for
materials in (tblProducts, frmProducts)and a tbl and a
form for materials out (tblTransaction and
frmTransaction), each product has a unique product ID
which will be same for both tbls and a job number feild,
the jonnumber for materials in is always the shop job
number 8645 and never changes but in tblTransaction it
will be different from transaction to Transaction. I also
need to deduct what goes out from what comes in the shop
to refelect the current status of specific item. I have
been able to do this dedeuction using a different table,
a query and a subform on the frmTransaction but it
doesn't change the value of the UnitsInStock after the
Transaction was made.

Please help put some light into my path by helping me on
ways to define the relationship between theses two three
tables and ways to have the value of the UnitsInstock
replaced after a transaction is made.

Your help is greatly appreciated.

Regards,

MD

The times are

Date: Wed, 17 Sep 2003 19:40:58 -0700

and

Date: Wed, 17 Sep 2003 21:35:57 -0700

OK, two hours apart not one; but on the same day, not a week apart.