How to get my Check box to correspond to a certain row in a table multiple times

[Paul-ish]

I have a check box on my form that I want to modify a certain value in a tables data. That isn't the hard part necessarily, the problem comes in when I need multiple check boxes on me table that all correspond to the same table, but different records in it.

My example is i have my table

|TableID|
|YesNoValue|

I have my form which creates a bunch of theses records in the table for the different check boxes, and my question is, how do i make the check boxes only correspond with their record in the table? When I change their data binding, its only generally for the YesNoValue in the table, but not specifically which row. Can anyone help me? I have a feeling there is a tutorial for this kind of thing maybe, although Google was fruitless for me. Thanks

 

[MarkK]

You need a datasheet or continuous form. These display many records from a table.
You also say your form "creates a bunch of tables." This seems like a bad idea.

 

[Paul-ish]

You also say your form "creates a bunch of tables." This seems like a bad idea.

I just don't know the lingo . I wan't to keep my database normalized so thats what i have been told to do.

EDIT:

I made a bad mistake, i said table instead of record in some places. Sorry, i edited the post.

 

[MarkK]

You've been told to create numerous tables to normalize data?
I don't really understand what you're trying to do. Your description suggested to me that you want to display multiple records from a single table. To do this use a continuous form or datasheet.

 

[Paul-ish]

You've been told to create numerous tables to normalize data?
I don't really understand what you're trying to do. Your description suggested to me that you want to display multiple records from a single table. To do this use a continuous form or datasheet.

The problem with a data sheet is that the person I am making the database wants the forms to be really user friendly. He has been using excel and says its about to make him go insane, and he just wants to tick check boxes.

Oh yea, i don't know if you caught my edits but i made a mistake. Not new tables, but new records. I need the check box to correspond to the correct record.

 

[MarkK]

Which leaves you with a continuous form, which can display as many check boxes as you like.