Too many fields to link?

[Robear Dyer]

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?

 

[pcs]

i'm trying to get a mental image of a form with 341 fields on it...

you might be able to create a query with multiple tables, but access will only allow 255 fields in a query. if you don't really need ALL the fields, this would be the way to go, as you could just select the fields you need. i suspect you might want to look at the over-all design for normalization.

al