Nope. In the 1st step you pick the table that you want. I understand that you cannot update a primary key since each time it auto increments with a new number. That makes it unique.
Actually now I have 2 questions.
I can make recordsets simple (one table) or (two tables) complex. I created a rs that had the company name and optionsID's. have the sql below. Now I can see the company and the optionID. I need to update the options for each company. I am looking for the best way possible to do that. Would that be form assist?
The CompanyIndexTable has these fields.
The OptionsID is tied to the OptionsTable that has Twitter,Facebook and webpage (3 options) and I can pick the number. What is the best way to what the name that is selected and not the number?
SELECT companytable.companyName, companyindextable.optionsID, companyindextable.optionsID2, companyindextable.optionsID3, companyindextable.optionsID4
FROM companytable, companyindextable
WHERE companytable.companyID = companyindextable.companyID