Client/server DB using Access-ASP-VBScript 
Author Message
 Client/server DB using Access-ASP-VBScript

I have managed to build a nice db that people can connect to through the
intranet, still I want more.
I want my associates to be able to use an old Post as a template.

main table:             Subtable:       No relation in Access....

OrderID(autonr)         ProductID(autonr)
Name                    OrderID(nr)
Age                     Name_of_prod

The First Post would look like this
main table:             Subtable:

OrderID=1               ProductID=1
Name=Norton Smith       OrderID=1
Age=36                  Name_of_prod="Banana"

                        ProductID=2
                        OrderID=1
                        Name_of_prod="Mango"

The OrderID is the glue that keeps thing together.
The next year I want to make a new similiar order, a hard work, still
I remember that I have done the Job before and I pick up the Old Order.
OrderID in the main table will now be 4096, I change my age to 37,
When I save this record I have only managed to change OrderID in the
Main table and saved the post under this new ID, not in the sub table,
it is still OrderID=1 and the connection is broken.

So My simple question is If I can copy the aboves ProductID 1 and
ProductID 2 and add OrderID 4096.
Copy is the solution.............

Please reply on my mail! I'll be pleased.

mvh. ingimar



Tue, 23 Nov 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How to Insert A String Variable into an SQL Statement using VBScript/ASP/Access db

2. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

3. Visual Basic App using Foxpro DB vs Access DB vs SQL Server DB

4. How to get SQL data from Server into Excel on Client using ASP

5. Access 97 as Client / Server DB??

6. connection to MS Access DB on server from Client

7. NEWBIE - how do I get VBscript to write to an Access db from an *.asp page

8. OLE DB in sql - server using asp

9. Strange behavior of VBscript/WMI into ASP (compared to VBscript/WMI into client-side application)

10. fat client (MSMQ, VB Program) or thin client (ASP page then have Web server use MSMQ)

11. Unable to run ASP with ActiveX Conrol on the server using VBScript

12. Client-side VBScript and Server-side VBScript?

 

 
Powered by phpBB® Forum Software