Using ASP to Update Relational Tables in Access

[monkeymagic2222]

Hi,

I'm trying to create an ASP/MS Access system to allow our Company to create internal purchase orders through the intranet. So far I have set up half a dozen Access tables, two of which are linked. These are tblOrder which is linked to a table called tblItem using a one-to-many relationship. The idea I have in my head is for each Order number, x number of items can be added to it.

I'm fine with the Access bit but I don't know where to start in order to get the ASP bit working correctly? I want to first let the user tap in a unique order number, record this to tblOrder then intelligently add rows to tblItem relating to that order number, depending on the amount of items the user wishes to add.

Any help/guidance is greatly appreciated!

Cheers,

 

[TonyU]

[tt]

How much ASP experience do you have?
<%
if your answer = Little to None than
read this =

http://www.yaxoo.com/books/Scripting/Ebook - A_Practical_Guide_to_ASP.pdf

else

Create a recordset pulling every field from your tables\query displaying all data. Then attach a link to a particular field in your display page with a link appending the ID number for that record, then on the page that is linked, select everything where the ID field = the id you're passing in the url...
enf if
%>


The link I provided above should get you started on the basics of ASP (if not) you can also visit these sites:

http://www.asp101.com

http://www.aspfaq.com

http://www.wdvl.com/Authoring/DB/Intro/toc.html

http://www.4guysfromrolla.com/

http://www.w3schools.com/default.asp

​

 

[monkeymagic2222]

Thanks for that, I will check out those links.

I have a fair bit of experience of ASP, i've used it quite extensively to add/view and update database records etc. but never to update linked tables. I had a go at using AddNew to add a new entry to this table but kept getting various errors even though the code was identical to what i'd used before. I was basically wondering if you had to use a different method to add new records to a linked table or anything, as even displaying records from parent table fails.

Thanks again,

 

[monkeymagic2222]

Figured out the problem(s)!

I should have used a Right Join when viewing the detail but the reason why the SQL wouldn't update the database was because I had a table called Order and I have just realised Order is a reserved SQL statement so I had to rename the table.

 

[TonyU]

[tt] Cool

[ul][li]What do all these errors in ASP really mean? ....

http://www.aspfaq.com

[/li] [li]What are the many ways to send emails with ASP? ....

http://www.aspfaq.com/show.asp?id=2119

[/li][li]Where can I learn ASP? ....

http://www.aspfaq.com/show.asp?id=2183

[/li][/ul]
[/sup
​

​