Making it Easy on the user

[jonathan]

Hi Everyone,

I want to have a data page for users to input items in a warehouse without
them having to type everything in, basically I want them to type a product
code then the rest of the fields (Barcode, Description, Cost etc) are
automatically filled in for them, finally leaving them just to add a
quantitiy.

Therefore this is want I want to achieve

Field 1 - Product Code (user inputs a product code)
Field 2 - Product Description (filled in automatically based on users input
code)
Field 3 - Barcode (filled in automatically based on users input code)
Field 4 - Cost Price (filled in automatically based on users input code)
Field 5 - Selling Price (filled in automatically based on users input code)
Field 6 - Locations (user inputs a warehouse location from a list box)
Field 7 - Qty (User inputs a qty)

The only fields I don't know how to code are fields 2, 3,4 & 5.

Can anyone help me?


tia

Jonathan

 

[Stefan B Rusynko]

You will need a database solution
See http://support.microsoft.com/default.aspx?scid=kb;en-us;287993&Product=fp2002




| Hi Everyone,
|
| I want to have a data page for users to input items in a warehouse without
| them having to type everything in, basically I want them to type a product
| code then the rest of the fields (Barcode, Description, Cost etc) are
| automatically filled in for them, finally leaving them just to add a
| quantitiy.
|
| Therefore this is want I want to achieve
|
| Field 1 - Product Code (user inputs a product code)
| Field 2 - Product Description (filled in automatically based on users input
| code)
| Field 3 - Barcode (filled in automatically based on users input code)
| Field 4 - Cost Price (filled in automatically based on users input code)
| Field 5 - Selling Price (filled in automatically based on users input code)
| Field 6 - Locations (user inputs a warehouse location from a list box)
| Field 7 - Qty (User inputs a qty)
|
| The only fields I don't know how to code are fields 2, 3,4 & 5.
|
| Can anyone help me?
|
|
| tia
|
| Jonathan
|
|

 

[jonathan]

Hi Stefan,

Thanks for this information but I think I didn't make myself clear,

The "DIW" is fine but not exactly what I am trying to achieve.........

I am wanting the fields to auto fill with the details that go against the
product code e.g.

when the user enters 12345678 in the field for the product code on the form
the other fields (which I need to lock) will auto complete with tthe details
that are stored in the database that go with that product code, so then the
user can then add a qty before clicking "add", does that make more sense?

Regards

Jonathan

 

[Stefan B Rusynko]

Which means you will need to query the database on change in the product code field to look up and get the data for the other
fields - using ASP code




| Hi Stefan,
|
| Thanks for this information but I think I didn't make myself clear,
|
| The "DIW" is fine but not exactly what I am trying to achieve.........
|
| I am wanting the fields to auto fill with the details that go against the
| product code e.g.
|
| when the user enters 12345678 in the field for the product code on the form
| the other fields (which I need to lock) will auto complete with tthe details
| that are stored in the database that go with that product code, so then the
| user can then add a qty before clicking "add", does that make more sense?
|
| Regards
|
| Jonathan
|
|
| | > You will need a database solution
| > See
| http://support.microsoft.com/default.aspx?scid=kb;en-us;287993&Product=fp2002
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| | > | Hi Everyone,
| > |
| > | I want to have a data page for users to input items in a warehouse
| without
| > | them having to type everything in, basically I want them to type a
| product
| > | code then the rest of the fields (Barcode, Description, Cost etc) are
| > | automatically filled in for them, finally leaving them just to add a
| > | quantitiy.
| > |
| > | Therefore this is want I want to achieve
| > |
| > | Field 1 - Product Code (user inputs a product code)
| > | Field 2 - Product Description (filled in automatically based on users
| input
| > | code)
| > | Field 3 - Barcode (filled in automatically based on users input code)
| > | Field 4 - Cost Price (filled in automatically based on users input code)
| > | Field 5 - Selling Price (filled in automatically based on users input
| code)
| > | Field 6 - Locations (user inputs a warehouse location from a list box)
| > | Field 7 - Qty (User inputs a qty)
| > |
| > | The only fields I don't know how to code are fields 2, 3,4 & 5.
| > |
| > | Can anyone help me?
| > |
| > |
| > | tia
| > |
| > | Jonathan
| > |
| > |
| >
| >
|
|

 

[Peter Aitken]

Hi Stefan,

Thanks for this information but I think I didn't make myself clear,

The "DIW" is fine but not exactly what I am trying to achieve.........

I am wanting the fields to auto fill with the details that go against the
product code e.g.

when the user enters 12345678 in the field for the product code on the form
the other fields (which I need to lock) will auto complete with tthe details
that are stored in the database that go with that product code, so then the
user can then add a qty before clicking "add", does that make more sense?

Regards

Jonathan

You will have to write ASP code that does the following:

1. When the user enters a part number, sends a query to the database that
says "send me the details for part # xxxx"
2. WHen the data comes back from the database, sticks it in the relevant
form fields.