I am having a bit of a problem. I don't have much mysql experience and am faced with a problem. I am using a menu to select a field called 'businessname' in a table called users. On submit this value is added to a field called 'businessname' in a table called paymaker. Here is my problem. I need to also get the field 'ID' from the same record in users and add it the the table paymaker in a field called 'userid' along with the original value 'businessname'.
So what I am trying to say is that I need both fields from the same record that I select in the menu. I have asked this question before, but was a little confused about the responses due to my limited experience with sql.
My pages are ASP VBscript and my database is msaccess. So is there someway that when I pass the businessname record that it automatically brings the ID with it?
Please help me. And if possible make it simple for me to understand