JQuartermaine
asked on
Creating Web Application to accompany Access Contact Database
I created a relational Access Database as described in this previous thread:
https://www.experts-exchange.com/questions/21360503/Help-with-Contacts-Database-reworking.html#13614326
I am now developing the Web Interface to accompany this in dreamweaver MX 2004. I am using standard ASP, and am presenting the first of my questions.
I need to find a way to create the master contact record first in my database, then be taken to a page to directly edit it. My dilemma here is that at this point I don't know the primary key ID for this entry, and therefore can't do it my usual way with passing the ID. Any ideas for this? Or if anyone knows a better way to handle this that would be great. I also do not wish to just pull the last record created in the database as multiple users can and will be using this at the same time.
Thanks
-JQ
P.S. In the link above to the previous thread, there is a kink to a recent screenshot of my database at the bottom of the thread.
https://www.experts-exchange.com/questions/21360503/Help-with-Contacts-Database-reworking.html#13614326
I am now developing the Web Interface to accompany this in dreamweaver MX 2004. I am using standard ASP, and am presenting the first of my questions.
I need to find a way to create the master contact record first in my database, then be taken to a page to directly edit it. My dilemma here is that at this point I don't know the primary key ID for this entry, and therefore can't do it my usual way with passing the ID. Any ideas for this? Or if anyone knows a better way to handle this that would be great. I also do not wish to just pull the last record created in the database as multiple users can and will be using this at the same time.
Thanks
-JQ
P.S. In the link above to the previous thread, there is a kink to a recent screenshot of my database at the bottom of the thread.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.