I created a relational Access Database as described in this previous thread:
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.
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.