Order Entry Form within Dreamweaver MX

[tforr]

Hi,

I want to use Dreamweaver MX to build a simple order entry form. I will use MS Access to build the database. I will therefore need to build a login form, admin form, order entry form, customers form, employees form etc within DW MX.

I wanted to know if anyone has done something like this before so I can have some sound advice. I would also like to know how long it will take to do. I'm sure it will be a good way of learning. I know I will be able to create the tables within access and normalize them. It seems to be just a matter of setting up Dreamweaver MX as the interface.

Thanks and kind regards,

Tom

 

[darrync]

try the tutorials in the help menu -- it will take some practice but some time will need to be put in -- O not to mention effort

 

[lebisol]

Hi tforr!
as Darry menitoned it...use the Tutorials from DW to get the "scale of your speed".
it is rather hard to give u a firm "time frame" as it really depends on your ability to pick up tips & tricks.
DW is a great WYSIWYG editor/tool by itslef and will most definetly cut down on tedious codeing of "simple HTML" but certain things will only be accomplished through "hard code".
My adivce is...try to look at the DW genrated code as you go along with tutorials.
and of course, come back and ask questions to specific issues you have.


:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:

 

[tforr]

Thanks for the advice Lebisol. My Order entry form seems pretty straight forward.

Cheers,

Tom

 

[lebisol]

tforr!
try this site as well:

http://www.dmxfire.com/articles/index.asp

used to be udnewbie.com
GREAT info is barried under the links!


:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:

 

[tforr]

Hi Lebisol,

Thanks for yet another good reply. Try

http://www.webthang.co.uk.

- Let me know what you think.

I have been going through my design and feel that it would be great if I set up a web site with my a order entry database and a number of admin pages. I can then create links from other websites that want access to my database and admin pages. I will have a login page therefore each company will have a username and password. I understand all the above and think I can code it but I want to know if you think this is the right logic.

Also is it possible to have it so when a user logs in they have their personal order entry page. This is because I have just found out that all browsers cannot have the same order entry form with a conventional company name drop down combo box simply for security reasons i.e. I could potentially select any company name and when the database is updated the data will be incorrect.

Any suggestions out there.

Cheers,

Tom

 

[Cheech]

a variable from the database can be used to only allow access/update to that users details

[Peace][Pipe]

 

[tforr]

Hi Cheech,

Can you explain in more detail please. Much appreciated.

Kind regards,

Tom

 

[Cheech]

Okay in your login table have a field called fldCompany, assign unique company names in there. Now on your subsequent pages you can only select records that match the company of the person logging in.

Cheech

[Peace][Pipe]

 

[tforr]

Brilliant. Thanks for the valid information. I will give it a go then.

Cheers,

Tom

 

[lebisol]

tfor
take a close look at:

http://www.dmxfire.com/articles/login/

this will match your idea of "personalized login page"


:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------: