Form Issue

[Michael Sainz]

Hey all,
I have an order form that i'm building and it links to a SQL database to
place orders. I'm having a hard time though figuring out how i'm going to
request a part and get the product ID. Here it is.

I have a table called Orders, and a table called OrderDetails. As you can
guess, OrderDetails are the line items for an Order. The form is based off
of this for the main connection. I have a secondary lookup table called
Products which you guessed it, contains all the product information.

In my form, my users need to be able to type in product model numbers, and I
need to get back productID so it can be placed in a OrderDetails record. How
would I go about doing this without doing any code? Sure hope it's possible.
Any help is much appreciated.

Michael

 

[Henning Krause [MVP - Exhange]]

Hello Michael,

I assume you have a textbox where the users enters the product number.

Depending on the size of your product database, you may not have to code...

You can add a rule to the textbox so that it updates another textboxes with
the productid. But this will first get the entire product table from the
database. If you want to fetch only the one record from the database which
matches your product-number, you'll have to code some script or managed
code.

Greetings,
Henning Krause [MVP - Exchange]
==========================
Visit my website: http://www.infinitec.de
Try my free Exchange Explorer: Mistaya
(http://www.infinitec.de/software/mistaya.aspx)

 

[Michael Sainz]

Thanks for the reply.

Yea...the product database is around 9000 records so it's getting big. I
wouldn't mind the initial pause while it loads the form to get all the data,
but since my textboxes are in a repeating section, every time they add a new
line it pauses for something. Would I be better off doing managed code or
creating a Web Service? Heh...both is hard work as I have to try and learn
VB.NET real quick.

Michael

Hello Michael,

I assume you have a textbox where the users enters the product number.

Depending on the size of your product database, you may not have to
code...

You can add a rule to the textbox so that it updates another textboxes
with the productid. But this will first get the entire product table from
the database. If you want to fetch only the one record from the database
which matches your product-number, you'll have to code some script or
managed code.

Greetings,
Henning Krause [MVP - Exchange]
==========================
Visit my website: http://www.infinitec.de
Try my free Exchange Explorer: Mistaya
(http://www.infinitec.de/software/mistaya.aspx)

Hey all,
I have an order form that i'm building and it links to a SQL database
to place orders. I'm having a hard time though figuring out how i'm going
to request a part and get the product ID. Here it is.

I have a table called Orders, and a table called OrderDetails. As you can
guess, OrderDetails are the line items for an Order. The form is based
off of this for the main connection. I have a secondary lookup table
called Products which you guessed it, contains all the product
information.

In my form, my users need to be able to type in product model numbers,
and I need to get back productID so it can be placed in a OrderDetails
record. How would I go about doing this without doing any code? Sure hope
it's possible. Any help is much appreciated.

Michael