the two tables idea sounds good. how would i go about linking them with query?

Rabbit, thanks to you I realize now that the description I have written wasn't clear. For some reason the client wants some information to be stored only on the form entries and not in the table. In other cases I used some workarounds which meant doing things in a more messy way and using some unbound controls (for instance, rather than using a combobox to allow multiple choice, which the client said was inconvenient, I used unbound checkboxes)....

Hey Seth thanks a lot for your reply. I'm not sure exactly how to go about what I need to do. I have a form which is a questionnaire, and there is some information that I want to keep on the form but not on the table. The problem is that this information comes from people filling the questionnaire (meaning that it should change with each entry) do you know how I can go about it? If there's no way to do that, do you know where i can find out binding...

I have a form that has some unbound controls. I have created a button that will clear them when clicked (otherwise, these controls are not cleared when creating a new entry). Thing is, this button also clears the controls on previous entries. Is there a way to clear these unbound controls only for the current entry (or lock the info of previous entries so that changing them will be impossible)?