Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Double entry when editing, line break in field


This topic is 7641 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Hello,

I am having two problems I can't figure out. When I use the database on the desktop, the problems do not occur. They only occur when looking at the database in a browser. I am using IWP. I know, I know, use CWP. I will, just not yet.

1. If I edit a field that has a pop-up list, the value remains in the field and so does the newly edited value I just chose. If I edit any other field that does not have a pop-up list, there is now problem with that field. However the pop-up list fields will have the values twice in the newly edited record. What causes that?

#2 If I create a new record the fields with pop-up menus have a line break right before the chosen value. This moves the value down in the field where it can't be seen. If I go to the table view I can see everything just fine, but all the values start on a second line in each table cell. How can I get rid of that line break?

Hope this is enough information to go on.

Tom

Posted

Hello,

I decided to attached the the database here because I think that is the only way for someone to see what I am doing wrong. And I'll try to clarify what I wrote above.

This database is the beginnings of an index of newspaper articles. It will mainly be used by the staff to do a weekly indexing of each article. They in fact are using a FM database that works perfectly fine but it needs some improvements. Another person and I had developed an improved index database that did not have the problems described above or below. But our latest work has some chinks in it. We can not see the difference between the two.

Problem 1: When creating a new record the author and subject fields display a line break and then the value. This pushes the value off-screen. Why is there this line break? If we create new records from the desktop there is no problem. Only when we go thru the browser does this problem happen.

Now here is the real mystery (for me): The first author field works perfectly fine, but not the second one. It should be simple to find what is different about them, but there is none that I can see, with one exception. Both fields use the same value list from the first author field. Changing that to using its own value list does not solve the problem.

I have even copied from the old good database the fields and important them into the newer one. But the fields get transmuted somehow, displaying the same problem.

Problem#2: When a record is edited, the old value in an author or subject field is not erased but simply moves down lower in the field, allowing the edited information to appear on top. Further, even if I don't edit a field, the value duplicates itself. Again, none of this happens on the desk top, only in the browser.

In the attached database, I have deleted all but about 8 records so that it is smaller and simpler.

If you look at Entry ID #'s 5 and 6 you can see the not-quite-edited problems. If you look at #46973 (the last record, see how many I deleted?) you can see an example of the offending line break.

If you do a search by going to the search page and writing >1 in the Entry ID field all of the records will appear. If you go to "View as Table" you can see all the problems nicely lined up.

Thanks for any help you can give.

Tom

Index.zip

This topic is 7641 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.