I hope someone can help!!! I have an either or problem. I need to add a field from another table onto my form and don't know how after the form has been created. I tried creating a new form using multiple tables but when I add all of the fields (there are about 60 fields)in one table plus 3 fields from another table I get a message that says the wizard can not create the table.

I can create the form with about 3/4 of the fields and the fields from the other table or I can create the form with all the fields in one table without bringing in any fields from the second table.

Either solution would work But I prefer to add to add the fields from a second table as everything in the form is already formatted. Any help would be greatly appreciated.

First try making sure your tables are well defined. Make sure they are normalized and that you have relationships established between them. Then you will probably want to make a query using your tables to base the form off of. I believe that if you try to use a wizard to create a form off of two tables, Access will assume a one to many realtionship, but maybe it doesn't.

I believe my fields are well defined but I'm not familiar with what normalize is. I can make 2 forms with no problem if I breakup the number fields. For example, if I use 3 fields from 1 table and 40 out of 60 fields (approx.)from the second table, I can create the form. Then if i use the same 3 fields from the first table and the other 20 fields from the second table, again, no problem. But, if I try to make one table from the 3 fields from the first table and try to use all of the 60 fields from the second table, I get the message that the wizard can not create the form. Why not????

What suggestions do you have???