I have a form that has values from many different tables. Here are the
tables:
- Questions(ID, UserID, Question)
- Users(UserID, Name, Email_Address, Other_Info)
So when I browse through each record, I see the question and who
submits the question. I can also modify the fields of both tables.
However, when I want to add a new question, I can start filling out the
question (it creates a new record in the Questions table). That also
creates a new record for a new user, which I don't want unless that the
user is not already in the database. So I'd like to use the user's
email address as a unique keyword to search to see if they're already
in the database. By typing the email address into the field and click
on "Search" or something, that will automatically fills in all other
fields (UserID, Name, Other_Info, etc.) into the form -- assuming the
user's already in the dB. If the user is not in the database, it
should allow me to fill in their information with a new record. Can
somebody walk me step-by-step through this? I'm such a newbie to
access.