Access Form Help

[Igawa29]

I have never attempted this type of form question capture and was looking for a little help.

I have 1 table with ID, Name and Description

I need a form that displays the Name and Description to the user with the following button choices:
Favorite, Yes, Maybe, No

Then depending on what the user selects that choice will populate a new table (out of 4 possible tales) : Table Favorite, Table Yes, Table Maybe, Table No

Then the Name and Description on the form moves to the next record.

I want this to go through all 360 records for each question until the user reaches the end. At the end the 4 new tables should be populated with results.

 

[MajP]

You would have to do that with some code attached to an option group. Then you would run an insert query based on the choice. However, can you explain why 4 tables, instead of 1 table. Does not sound normalized.