Soundsmith
Programmer
I'm going to try to avoid details on this one, all I'm looking for is help figuring out how to troubleshoot the problem-a full explanation would take all week!
I'm trying to create a form to handle 'exception' records which contain insufficient info to be automatically matched to the primary tables. One Case may have multiple Claims, and in a few instances, the same Claimno with a different aid_cod (different primary key.) The primary key for the primary tables is, therefore, a composite of caseno, claimno and aid_cod. Transaction records contain this key plus a transaction detail-trans_type_code, trans_amt, etc.
The exception records typically either are missing some element of the primary key, usually claimno, or the balances are mismatched, as the records come in in random order, but MUST go into our system in their proper order, and we can't change the import record structures (they come from the state, and it takes years to get ANY change incorporated, even if the approval committee agrees...
A human worker can look at these records and the existing transactions to compare and match them up. My current form has the exception records listed by Caseno only, with a subform showing all records matching the caseno (continuous display.) The form also displays all cases in the system with that case number. The idea is for the worker to pick a primary case, and assign exception records to it in their proper order.
When the records have been identified (the new sequence number is entered on the subform) I have the user click on a command button which appends records into tblTest, first all records which match the primary key from the main tables, then the records which have been identified from the exception table. This part works fine. I can stop the process at this point and examine the table, all the records are there.
Now click on tab 2, opening the page to a subform which displays the tblTest records. If I do this directly, clicking on the form button in the database object window, all the records are there and display properly. When I do this with the subform on the tab page, MOST of the time, the form is blank-no records, no empty fields, nothing. But OCCASIONALLY, I'll get the data. I cannot find any logic to describe when this will occur-I can page through the system, and about one out of 10 or 12 will display.
Does anybody have an idea where I should start looking? I'm not using recordsets, just creating and displaying the tables on the fly. Filters are set off, and I'm stumped.
Thanks for any help you can offer. David 'Dasher' Kempton
The Soundsmith
I'm trying to create a form to handle 'exception' records which contain insufficient info to be automatically matched to the primary tables. One Case may have multiple Claims, and in a few instances, the same Claimno with a different aid_cod (different primary key.) The primary key for the primary tables is, therefore, a composite of caseno, claimno and aid_cod. Transaction records contain this key plus a transaction detail-trans_type_code, trans_amt, etc.
The exception records typically either are missing some element of the primary key, usually claimno, or the balances are mismatched, as the records come in in random order, but MUST go into our system in their proper order, and we can't change the import record structures (they come from the state, and it takes years to get ANY change incorporated, even if the approval committee agrees...
A human worker can look at these records and the existing transactions to compare and match them up. My current form has the exception records listed by Caseno only, with a subform showing all records matching the caseno (continuous display.) The form also displays all cases in the system with that case number. The idea is for the worker to pick a primary case, and assign exception records to it in their proper order.
When the records have been identified (the new sequence number is entered on the subform) I have the user click on a command button which appends records into tblTest, first all records which match the primary key from the main tables, then the records which have been identified from the exception table. This part works fine. I can stop the process at this point and examine the table, all the records are there.
Now click on tab 2, opening the page to a subform which displays the tblTest records. If I do this directly, clicking on the form button in the database object window, all the records are there and display properly. When I do this with the subform on the tab page, MOST of the time, the form is blank-no records, no empty fields, nothing. But OCCASIONALLY, I'll get the data. I cannot find any logic to describe when this will occur-I can page through the system, and about one out of 10 or 12 will display.
Does anybody have an idea where I should start looking? I'm not using recordsets, just creating and displaying the tables on the fly. Filters are set off, and I'm stumped.
Thanks for any help you can offer. David 'Dasher' Kempton
The Soundsmith
