M
Mauro via AccessMonster.com
I have a FE/BE application with a linked ODBC table from my PO system. The
PO number is a concatenate number from at least the first 9 rows of the
ODBC table. So, to have the PO number, I need to make a "make table query"
in my FE concatenating these rows and then send it back to the BE as "PO
table" to use it later with another table called "invoice".
There is no common data in both tables to create a query, so I created a
lookup colummn in my "invoice" table linked to "PO" table, so for each PO
number I can have many invoices.. Then I created a Form based on my "PO"
table and a subform based on my "invoice" table.
At this point everything looks to work perfect but the only "embarassing"
process is to update my "PO" table as PO's are added to my ODBC linked
table..
1st. question: Is there a manner to update my "PO" table automatically? I
actually do creating an append query..
The second part of my problem is that I created another form (called
"forwarder") to allow users to input data through check boxes.. This form
has to calculate a "third party invoice" amount based on my system invoice
information. For example, my system invoice number "0001" has a third party
invoice associated based on the different items selected by the user,
giving me a "third party invoice" ammount. What I have done so far is
created a query with all these "items" in calculated fields, so when a user
click on a check box, it calculate a value based on a "tariff table". This
has been working perfectly in a stand alone database, but when I split my
DB into FE/BE, my form "forwarder" that is based on a query, resides in the
FE and not in the BE.
2nd. question: How do I make this "third party invoice" information
available to all users? What happend when two or more users are feeding
this information at the same time?
I hope I have been clear enough explaining this stuff to all of you..
I really appreciate any help/hint to solve this issues..
Mauro
PO number is a concatenate number from at least the first 9 rows of the
ODBC table. So, to have the PO number, I need to make a "make table query"
in my FE concatenating these rows and then send it back to the BE as "PO
table" to use it later with another table called "invoice".
There is no common data in both tables to create a query, so I created a
lookup colummn in my "invoice" table linked to "PO" table, so for each PO
number I can have many invoices.. Then I created a Form based on my "PO"
table and a subform based on my "invoice" table.
At this point everything looks to work perfect but the only "embarassing"
process is to update my "PO" table as PO's are added to my ODBC linked
table..
1st. question: Is there a manner to update my "PO" table automatically? I
actually do creating an append query..
The second part of my problem is that I created another form (called
"forwarder") to allow users to input data through check boxes.. This form
has to calculate a "third party invoice" amount based on my system invoice
information. For example, my system invoice number "0001" has a third party
invoice associated based on the different items selected by the user,
giving me a "third party invoice" ammount. What I have done so far is
created a query with all these "items" in calculated fields, so when a user
click on a check box, it calculate a value based on a "tariff table". This
has been working perfectly in a stand alone database, but when I split my
DB into FE/BE, my form "forwarder" that is based on a query, resides in the
FE and not in the BE.
2nd. question: How do I make this "third party invoice" information
available to all users? What happend when two or more users are feeding
this information at the same time?
I hope I have been clear enough explaining this stuff to all of you..
I really appreciate any help/hint to solve this issues..
Mauro