Creating form to populate a table in a specific way, question

[McArthurGDM]

Say I have a table of ID's that looks as such.

ID	Desc	Desc2
A1	...	...
A2	...	...
A3	...	...

And this ID table is connected to a Score table. As such. Where ID has a parent/child relationship via a form, of course.

ID	State	Score
A1	OH	1
A1	MA	2
A1	KY	1
A1	NY	2
A1	VT	4
A1	ME	7
A1	FL	1
A2	OH	2
A2	MA	3
A2	KY	1
A2	NY	3
A2	VT	3
A2	ME	2
A2	FL	1

However, let's say that I want to be able to add values to the score table. In this case, the States are considered constant (that is, there will always be a set amount - say, 50). I want the format of the form to look like this:



That is, they type in the ID once, the State field is already predetermined and all they really need to input is the value. And, somehow, the value table generates in the manner I displayed above.

Thanks,

[pbaldy]

One option would be to prepopulate your table with 7 entries, using your states (presumably held in a table) and the ID. Another would be an unbound form where clicking on a button would run code to create the records.