Too many fields to link?

[Robearpa]

I'm trying to create a form that combines 341 fields from 16 different tables. The tables are all linked by one-to-one relationships with an ID number field. The Forms Wizard is unable to create my form, apparently because I have too many fields. I tried creating a form using just one field from each table, but when I tried to go back and add in the remaining fields, I could not access my source tables. Is there a way I can create this form, or will I just have to set up a form for each table?

 

[tlbroadbent]

Have you considered creating a Main Form for the "Main Table" and sub-forms for the other tables? Terry

People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker

 

[raskew]

I sense a mega-spreadsheet to Access solution. Could this be true? Don't know if this site can handle 341 fields, but perhaps you'd post an example of your data.