Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kevinrea
Starting Member
2 Posts |
 Posted - 2004-06-29 : 22:58:53
|
| hi guys,i have a database that has one form.this form is a main form with a lot of subforms.the main form is tied to one table.each of the subforms has it's own tablei tried setting up relationships between the main table and all the sub tables, but after awhile of making the joins, access 2003 said 'too many relationships'.any way around this ?i have about 65 sub tables.thanks,kevin |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-07-01 : 13:39:37
|
| Are you saying that you're trying to represent data from 65 different subtables in one form?! Good grief that's a lot of stuff! In fact, if you've got one master table and 65 tables all directly related to it, my first thought is that your database may need a redesign. I can't imagine one table having 65 others all directly related to it.But, as far as your form goes, I'd give serious thought to using unbound forms and writing your own routines for reading and saving data. I do this a lot in Access, even without so many tables, because it gives me more control over the presentation of information to make it more usable instead of jumping through the hoops of sub-forms, etc. This approach also really gets your front end separated from your back end more and is a good step to take if you have any future plans of migrating to something like a VB/SQL combination.-----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
 |
|
|
|
|
|
too many tables for relationships