Forms from queries

[Kelly]

Originally, I set up my database so that all the forms and
subforms were created directly from the tables but, I was
having major problems printing. It was suggested to me
that I should create queries instead and make all my
forms/subforms tie into those queries. I have done that
but, now all my checkboxes are greyed out and when you try
to enter a check an error message pops up saying "You
can't assign a value to this field". Any idea how to fix
this?

Also, one of my queries is too big and will not work with
the form (too many fields defined). I tried making each
subform connect to a query with only the fields needed and
then I tried to make the main form connect to a query
containing records from the main table (including the rec.
no.) and the id from each of the other tables but, it
doesn't allow me to add any new records. Is there any way
to do this also?

 

[StCyrM]

HI Helly

Have you done a proper normalization of your tables?

 

[Kelly]

I'm not sure what you mean by this - how would I do a
proper normalization of the tables? What will it do?

Thanks!