Adding a field to a form from another table...

[Mitchm]

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.

 

[dhoffman]

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.

 

[Mitchm]

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???