Greetings all,
To be brief, a few months ago I created a nice MS Access DB to assists employees at my company with ordering office supplies. I was told after much effort that access didn't work well over our company wan. Now I am trying to create a web based verison of my Access form and I am extremely confused by all the MS software that is available for this purpose.
I have been goofing around with Visual Web Developer Beta and think that this may be the direction in which I wish to go...yet the transition is some what difficult. I know how to setup the Database yet I'm not sure of the controls/ code that I need to use...let me explain.
I need a simple form with controls to identify the user(Dropdownlist)....what
building(This could be autofilled by the dropdownlist...and a textbox that generates an incremental number after the form is complete or at the beginning...In MS access the next part of the form would be a subform...not sure what to use or how to do this in Visual Web Dev.
The subform would contain 6 controls...
the first would be another dropdown list(ProductID numbers) a description text box(Autofilled by the Dropdownlist)a textbox for Quantity...a textbox for Cost(Autofilled by the dropdownlist) and lastly a textbox for a linetotal(Quantity * Cost).
In MS Access the subform would generate additional "rows" as needed by the employee...I'm fairly certain this is not possible in Visual Web Dev but I might be able to fake it using a grid or table...
Lastly a command button that would print out a copy of the final form when the employee has completed the form.
Also I would need to be able to review the past "forms" so that they could be filled and shipped after the user has completed them.
If anyone out there has even the slightess idea of what I'm talking about and can point me in the direction of some books, online help or examples that I can review and learn from this would be a great help! Please understand that I do not wish for someone to do this for me I want to learn how to do this myself.
Thanks in advance!
Will Banks