Reflex_ht
Registered User.
- Local time
- Today, 03:03
- Joined
- Sep 11, 2012
- Messages
- 64
Hy,
We have a huge Database (relative huge
). Because of that I had to split the database on multiple tables to not lose performance. The main seperation is for every year and Terminal so I have now 6 tables with the same data and structure. Its making maintaining, changes and coding realy hard 
Tables:
tbl_DL_Salzburg_2012
tbl_DL_Salzburg_2013
tbl_DL_Munchen_2012
tbl_DL_Munchen_2013
tbl_DL_Ulm_2012
tbl_DL_Ulm_2013
At the end of every year we have more than 10 000 records in each table.
The second Problem for joining the tables is that i have to filter them on Terminal (Salzburg, Munchen, Ulm) and on Year (2012, 2013, 2014). The Form I use on that table is a split form (reason is the fast filtering and searching in the datashed).
The first problem with the large amount of records i can solwe with an sql server but there is still the problem with the filtering
I tryed to use the form RecordSource and an SQL statement but in that case (depends how the SQL is struktured and the RecordSource is used) the users cant add or delete records in the table. It shows them that the record is added or deletet but when they leav the form they are all gone
P.S. It´s an multiuser database. Making things more complikated
Does enyone know how to solve this second problem with filtering and not disturbing adding and deleting records.
I know that splitforms are not good but the users don´t want to use something other that also takes me away the solution with unbound forms
I would like to move to one table until the end of the year. If not I have to handle 9 same tables. Insane :banghead:
Is maby the filter on form load a solution?
We have a huge Database (relative huge
). Because of that I had to split the database on multiple tables to not lose performance. The main seperation is for every year and Terminal so I have now 6 tables with the same data and structure. Its making maintaining, changes and coding realy hard Tables:
tbl_DL_Salzburg_2012
tbl_DL_Salzburg_2013
tbl_DL_Munchen_2012
tbl_DL_Munchen_2013
tbl_DL_Ulm_2012
tbl_DL_Ulm_2013
At the end of every year we have more than 10 000 records in each table.
The second Problem for joining the tables is that i have to filter them on Terminal (Salzburg, Munchen, Ulm) and on Year (2012, 2013, 2014). The Form I use on that table is a split form (reason is the fast filtering and searching in the datashed).
The first problem with the large amount of records i can solwe with an sql server but there is still the problem with the filtering
I tryed to use the form RecordSource and an SQL statement but in that case (depends how the SQL is struktured and the RecordSource is used) the users cant add or delete records in the table. It shows them that the record is added or deletet but when they leav the form they are all gone
P.S. It´s an multiuser database. Making things more complikated
Does enyone know how to solve this second problem with filtering and not disturbing adding and deleting records.
I know that splitforms are not good but the users don´t want to use something other
that also takes me away the solution with unbound forms I would like to move to one table until the end of the year. If not I have to handle 9 same tables. Insane :banghead:
Is maby the filter on form load a solution?
) that i´m thinking to move on VB.Net.