A
Aurora
I am using Access 2000.
I created a program that keeps track of our customer
returns for several departments to use. I began with a
form that the sales dept uses to record all of the return
information required. This infor goes into DB-A.
Then when Accounting has to record their information, I
created a another form based on DB-A and DB-B, (DB-B
contains the information that Accounting has to enter.)
These two databases are tied together by a RMA#.
Originally, Accounting would enter the RMA# in the RMA#
field on her form and the required sales information, from
DB-A would come up on the screen. But we were getting
duplicate files in the Accounting DB.
So I tried to make it mistake proof by having the Acctg
form ask for a RMA# first, before bringing up the form.
If it was already there, the sales information should come
up automatically, but if it was not there a blank form
should come up and she could enter the RMA# and all of the
sales inform would come up. But this is not working
because DB-B does not have a corresponding record with the
RMA# yet. What does happen is that when the RMA# is
entered (because it is not in the DB-B, a blank form comes
up. If we go to the RMA# field and enter the number, none
of the sales information comes us. So we close the form.
Go back into the form. The request for the RMA # comes
up, enter the same number and now everything comes up like
it should. But this is double the work. How can I
simplify this procedure?
Does anyone have any ideas how I can accomplish what I
want to do. I am not good with writing code. I am hoping
there is something else I could do?
Aurora
I created a program that keeps track of our customer
returns for several departments to use. I began with a
form that the sales dept uses to record all of the return
information required. This infor goes into DB-A.
Then when Accounting has to record their information, I
created a another form based on DB-A and DB-B, (DB-B
contains the information that Accounting has to enter.)
These two databases are tied together by a RMA#.
Originally, Accounting would enter the RMA# in the RMA#
field on her form and the required sales information, from
DB-A would come up on the screen. But we were getting
duplicate files in the Accounting DB.
So I tried to make it mistake proof by having the Acctg
form ask for a RMA# first, before bringing up the form.
If it was already there, the sales information should come
up automatically, but if it was not there a blank form
should come up and she could enter the RMA# and all of the
sales inform would come up. But this is not working
because DB-B does not have a corresponding record with the
RMA# yet. What does happen is that when the RMA# is
entered (because it is not in the DB-B, a blank form comes
up. If we go to the RMA# field and enter the number, none
of the sales information comes us. So we close the form.
Go back into the form. The request for the RMA # comes
up, enter the same number and now everything comes up like
it should. But this is double the work. How can I
simplify this procedure?
Does anyone have any ideas how I can accomplish what I
want to do. I am not good with writing code. I am hoping
there is something else I could do?
Aurora