V
vuongp
I have 2 tables called "questions" and "submitter". The table
"questions" have a submitter_ID that is also a primary key in the
"submitter" table to keep track of who submits the question. I'm
designing a form to browse through the questions and the name of the
user who submits the question (instead of the submitter ID). My form
is bound? to the "questions" table, so what's the code I need to put
into the Data field of the textfield that allows the user to see the
name of the submitter (firstName lastName)? Currently the code in the
control field is "submitter_ID", but that only allows the form to
display the userID instead of the full name, which comes from another
table. I'm a complete newbie so if you could details the steps that
would be appreciated. TIA.
Here are the tables:
questions (ID, submitter_ID, question)
submitter (submitter_ID, firstName, lastName, emailAddr)
"questions" have a submitter_ID that is also a primary key in the
"submitter" table to keep track of who submits the question. I'm
designing a form to browse through the questions and the name of the
user who submits the question (instead of the submitter ID). My form
is bound? to the "questions" table, so what's the code I need to put
into the Data field of the textfield that allows the user to see the
name of the submitter (firstName lastName)? Currently the code in the
control field is "submitter_ID", but that only allows the form to
display the userID instead of the full name, which comes from another
table. I'm a complete newbie so if you could details the steps that
would be appreciated. TIA.
Here are the tables:
questions (ID, submitter_ID, question)
submitter (submitter_ID, firstName, lastName, emailAddr)