I sent this last night, the file was corrupted I'll try again with an added
explanation.
I'm have a problem with the deposit set in the attached database. The
records are entered through the deposit entry form. The form consists of tbl
deposit_head and an embedded browse of tbl deposit_line. Everything is
ok on the form and in deposit_line but some deposit_line records show
twice in the default browse for the set. These print out on the deposit slip
report twice� but are only added into the total once. They appear to be
some phantom records if I change a record in deposit line both records are
changed in the set browse.
When you look over the records notice that almost all records with a 5
digit check and $60.00 check amount are doubled along with random other
occurrences. The script that runs when the curser leaves the check number
field is to check the last check number of the donor and see if it is within
50 of the current check number it help catch entry errors.
I will try to explain the problem better
I know that all the records in child browse are duplicated in the set
browse. My problem is that some of the records are in the set browse
twice. If you open the deposit form go to the "April 5 test" deposit you
will see each record is in the deposit once. Now click on the print deposit
slip button you will see some records twice. The deposit slip total is
$595.00 The correct amount!
But the total of the amount column if you add it up is $775.00 The browse
for the set has the extra records.
I thought the ile downloaded I guess not I will try again
I am running a5v4.03 on a k62400 with 128meg of ram.
Thanks for any help
Ken Cameron
explanation.
I'm have a problem with the deposit set in the attached database. The
records are entered through the deposit entry form. The form consists of tbl
deposit_head and an embedded browse of tbl deposit_line. Everything is
ok on the form and in deposit_line but some deposit_line records show
twice in the default browse for the set. These print out on the deposit slip
report twice� but are only added into the total once. They appear to be
some phantom records if I change a record in deposit line both records are
changed in the set browse.
When you look over the records notice that almost all records with a 5
digit check and $60.00 check amount are doubled along with random other
occurrences. The script that runs when the curser leaves the check number
field is to check the last check number of the donor and see if it is within
50 of the current check number it help catch entry errors.
I will try to explain the problem better
I know that all the records in child browse are duplicated in the set
browse. My problem is that some of the records are in the set browse
twice. If you open the deposit form go to the "April 5 test" deposit you
will see each record is in the deposit once. Now click on the print deposit
slip button you will see some records twice. The deposit slip total is
$595.00 The correct amount!
But the total of the amount column if you add it up is $775.00 The browse
for the set has the extra records.
I thought the ile downloaded I guess not I will try again
I am running a5v4.03 on a k62400 with 128meg of ram.
Thanks for any help
Ken Cameron
Comment