I have been watching the threads concerning linked memo fields and other memo field issues for a while now, and have posted before. But still have not found a resolution to this problem. In my application, I have a button that opens a form and starts a new record. This form has 6 items on it: an auto increment number, a date field that is filled with todays date by default, a customer ID field that opens a menu based on a table, a customer name field that gets auto filled when I pick from the menu mentioned above, and a first and last name field that I just type in for a contact person. This is all part of a much larger form and table with many fields and quite a bit going on. There are quite a few memo fields in this app, but one in particular seems to be linked to this problem. This is what happens:
I pick the new record button, it opens the form, and fills the date and auto increment field and then pops open the menu to pick a customer ID. I select one and it fills the name as well and then goes into the first name box. MOST of the time it is blank, as it should be. But once in a while, the name from the previously made record appears in that box. If I then click into the last name box, the last name appears also from the previous record. At this point I usually cancel out and start over, usually to find the same thing. But if I save the record at that point, I find that the entire record has been duplicated.
Now comes the really weird part. I can overwrite all the fields in the record and not affect anything else EXCEPT one memo field. If I edit that field, the edit will take place in the record that was copied as well. And then if I go back and edit it there, the change takes place in the new one. I beleive they are not duplicates but the same memo, being referenced by two records. But it appears, at least at this point, that no other memo fields are being linked like this. I cannot get this to happen at will, and it always happens to someone else. Once I get it cleared, it might work fine for a week, or maybe only ten minutes, before it happens again.
And it is sometimes difficult to get the thing to stop wanting to link. The only sure way is to let it make that record, delete it, and then start over making a new one. But if I just cancel out, and try again, or exit A5 and re-open and try again, it will usually still want to link.
Can anyone shed a little more light on this? It is getting to be a real pain. Yes I know I should have avoided all those memo fields. But why have them if they don't work? Any help would be greatly appreciated.
Todd
P.S. I can send files if anyone would like to see them. But like I said, you might spend a month getting it to do this.
I pick the new record button, it opens the form, and fills the date and auto increment field and then pops open the menu to pick a customer ID. I select one and it fills the name as well and then goes into the first name box. MOST of the time it is blank, as it should be. But once in a while, the name from the previously made record appears in that box. If I then click into the last name box, the last name appears also from the previous record. At this point I usually cancel out and start over, usually to find the same thing. But if I save the record at that point, I find that the entire record has been duplicated.
Now comes the really weird part. I can overwrite all the fields in the record and not affect anything else EXCEPT one memo field. If I edit that field, the edit will take place in the record that was copied as well. And then if I go back and edit it there, the change takes place in the new one. I beleive they are not duplicates but the same memo, being referenced by two records. But it appears, at least at this point, that no other memo fields are being linked like this. I cannot get this to happen at will, and it always happens to someone else. Once I get it cleared, it might work fine for a week, or maybe only ten minutes, before it happens again.
And it is sometimes difficult to get the thing to stop wanting to link. The only sure way is to let it make that record, delete it, and then start over making a new one. But if I just cancel out, and try again, or exit A5 and re-open and try again, it will usually still want to link.
Can anyone shed a little more light on this? It is getting to be a real pain. Yes I know I should have avoided all those memo fields. But why have them if they don't work? Any help would be greatly appreciated.
Todd
P.S. I can send files if anyone would like to see them. But like I said, you might spend a month getting it to do this.
Comment