I have been dumped on this old database. The tables are not normalized. I am having a problem with the forms. I figured I needed to start from scratch and just import the data. The problem is the forms. The way it is set up now.

There are tables that hold static information. This information is pulled by combo boxes onto the form for user selection. All the information that is selected and inputed goes to 1 massive table. I am wanting to break this table apart so it will be normalized like the other tables that has been created. The problem is when I try to recreate the forms for the people to use it will not let me. The page keeps comming back blank when I run it. I am using a select statement as my control source for the form. I thought I could do this so the information would be put in the multiple tables. instead of the 1. I have the row source as the parent tables that is holding the static onformation.

How can I have one form store input information in multiple tables?

Any help would be appriciated.

Thanks.