I can't add more fields to table w/o the error Too Many Fields Defined

[MSWhat]

I am working form a database that has two related tables--Master List & Bank Account Info--which are joined in a Query, "Conglomerate," as the recordsource of my form. In aggregate the number of columns in both tables is at or near 255. I know that each individual table can only contain 255 columns, but it is my understanding that the form is not limited to this. Now, whenever I try to add one more field to a table, it allows me to do so--I can save it, etc. However, when I then try to open my form, an error message pops up, telling me that there are too many fields to open. This doesn't make sense to me since, while I've added a new column to the table, I haven't added a new field to the form, with the new column as its control source.

Perhaps this has something to do with the fact that the Record Source for my form is a query which contains both tables. I'm not even sure if that's the proper way to have a form be based off of two tables. But that's just a guess. In any case, I definitely need to be able to add more fields, so this is a serious problem.

>>>The SQL statement of my query, Conglomerate, which is the recordsource of my form is:
SELECT [Master List].*, [Bank Account Info].*
FROM [Master List] INNER JOIN [Bank Account Info] ON [Master List].[Transaction Name] = [Bank Account Info].[Transaction Name];

I tried compacting the database (several times, in fact), but that was absolutely no help.


Thanks to everyone for their help!

 

[PHV]

the number of columns in both tables is at or near 255
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MSWhat]

Thanks for the link, PH, but it unfortunately did not contain any information (though sounded like it might come close for a brief sentance) relevant to fixing this problem.

 

[MSWhat]

Still confused, but this conversation seems to have been relocated to an alternate thread. For all of those who are having similar problems and are looking for the answer, please check development on the thread "Saving one field in a form to multiple related tables, et al."

Thanks again to all who are helping me to resolve this frustrating, disabling problem.