Copying autoincrement ID value to another column when inserting a record
Hi Ray, I have three ID columns in a database, the first one is the primary index autoincrement ID, then I have two other INT columns, say they're called ID2 and ID3. These are used to give people access to specific areas of the website. I have it set up on the record update page so that when someone requests access to these areas, it copies the primary index value into the other two columns. However, how can I get the value of the primary index when adding a new record? Is there a way of getting this number when it doesn't actually exist until the record has been added?