Best way to validate

[Fairportjay]

I have a form with wish I wish to validate the following chart where x's are invalid entries. what would be the best method of validation? I tied to Canoncate the fields then run a simple validation but can't seem to get it to work... should I use subforms that only list the valid choices for each header? thanks in advance

	FCC	GFDC	CCC	Parent	Community	LE
ASQ				x	x	x
Baby_Doll_Circle_Time				x	x
Center_Continutity_of_Care"	x	x		x	x	x
FDC_Accreditation			x	x	x	x
Literacy_Connenction				x	x	x
Pyramid_Model
Vroom
New IT				x	x	x

[mike60smart]

Would suggest you need to eliminate the Invalid Entries first

[pbaldy]

Are you asking how to validate what a user enters? I'd have a table of valid combinations:

ASQ FCC
ASQ GFDC
...

The you can simply see if the combination exists to be valid, or use cascading combos:

http://www.baldyweb.com/CascadingCombo.htm