7 Replies - 1829 Views - Last Post: 21 February 2012 - 08:14 PM

#1 timosilver   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 117
  • Joined: 20-March 11

Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 10:24 AM

Hello,

Am developing a program that requires. questions and answers. I have a table for the questions, and table for the answers with four columns, how do i create this effectively to load the question and appropriate answers. one answer column being the correct answer. thanks
Is This A Good Question/Topic? 0
  • +

Replies To: Access: how to create a table for QUESTION and four ANSWER options

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15494
  • View blog
  • Posts: 62,051
  • Joined: 12-June 08

Re: Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 10:33 AM

Have a third table matching up question ids to answer ids and a bit column for "correct" would work in a jiffy.
Was This Post Helpful? 0
  • +
  • -

#3 timosilver   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 117
  • Joined: 20-March 11

Re: Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 10:42 AM

thanks for your reply. 'would work in a jiffy. ' those this mean it wont work perfectly?
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15494
  • View blog
  • Posts: 62,051
  • Joined: 12-June 08

Re: Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 10:44 AM

No, that means it would work as a quick solution.
Was This Post Helpful? 0
  • +
  • -

#5 timosilver   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 117
  • Joined: 20-March 11

Re: Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 11:01 AM

ok.. thanks.
Was This Post Helpful? 0
  • +
  • -

#6 timosilver   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 117
  • Joined: 20-March 11

Re: Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 11:18 AM

so now i have table 1 with id column and question column.
table 2 with id column and 4 answers column

how do i create table 3 for marching the corresponding ids of the 2 tables. how many column should table 3 have. Column for the bit.

Thanks Am new appreciate your kind help
Was This Post Helpful? 0
  • +
  • -

#7 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15494
  • View blog
  • Posts: 62,051
  • Joined: 12-June 08

Re: Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 11:36 AM

woah woah woah... You went off a different route than I expected.

If you have it set that way - why not just have *one* table with: id column, question (string) column, four answer (string) columns, and a "which answer is right" column (integer)?
Was This Post Helpful? 0
  • +
  • -

#8 timosilver   User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 117
  • Joined: 20-March 11

Re: Access: how to create a table for QUESTION and four ANSWER options

Posted 21 February 2012 - 08:14 PM

ok. great..!! thanks for the direction. well understood. will alert you if am lost again. God bless
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1