Sign in to follow this  
Followers 0
John Link

Problems with checkboxes in just one computer on a network

6 posts in this topic

I have FileMaker Pro 12 installed on four computers on my network, and FileMaker Pro Advanced 12 stored on a fifth computer. There is a shared database stored on one of the first four computers. When using the shared database from the fifth computer and I attempt to check any of the checkboxes for the field Events, I see the message shown in the attachment and I am unable to check the checkbox (This behavior occurs only on the fifth computer). If I then do a search, after doing the search I am able to check any of the checkboxes in the previously problematic field. I've restarted the fifth computer and the problematic behavior stills occurs.

Any suggestions?

Screen Shot 2017-02-13 at 11.44.33 AM.png

Edited by John Link

Share this post


Link to post
Share on other sites

That's a field validation error, check the field definition, validation tab for what rules it enforces; that will be the clue for what is wrong.

How are these files shared?  Through peer-to-peer and 'open remote'?  Are the files in a network share?

Share this post


Link to post
Share on other sites

Here are the windows that show the validation rules and the sharing of the database.

It seems very strange that the problem happens on only one of the computers, and that it goes away after I perform a search.

I trashed the preferences and the problem persists.

 

Screen Shot 2017-02-13 at 1.38.47 PM.pngScreen Shot 2017-02-13 at 1.35.42 PM.png

 

Edited by John Link

Share this post


Link to post
Share on other sites

I noticed the problem only today after I added the value "Salon 3-25-17" to the value list Events. The problem was not on the other four computers but persisted on the fifth computer after I removed "Salon 3-25-17" from the value list.

Here is the Inspector's info for the field Events.

58a201815e9ed_ScreenShot2017-02-13at1_55_43PM.png.c572f7be335865e79df49aa935183e0b.png

Here's a screen shot of the portion of the database where the field Events is displayed.

Screen Shot 2017-02-13 at 2.01.02 PM.png

From my Time Machine backup I installed the earliest backup (December 2015) I have of FileMaker Pro Advanced 12 and the problem remained.

Edited by John Link

Share this post


Link to post
Share on other sites

The problem is now occurring on all of the computers except the one hosting the database.

Edited by John Link

Share this post


Link to post
Share on other sites

I've discovered that the problem is isolated to the first record of the database. That's why doing a search would allow me to click on a checkbox in the field Events (because after the search I would be looking at a record other then the first). It also explains why the problem initially appeared isolated to one computer.

I copied the first record and then attempted to click a check box in the field Events of the duplicate record. The problem again appears in the duplicate record, so I will create a new record and copy each of the fields from the corrupt record to the new record and see whether the problem persists in the new record.

After copying each of the fields from the corrupt first record to a new record, I am able to check any of the checkboxes in the field Events without an error message. Furthermore, after deleting the corrupt first record, there is no problem with the record that is now the first record (previously the second record).

PROBLEM SOLVED!

Edited by John Link

Share this post


Link to post
Share on other sites

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
Sign in to follow this  
Followers 0

  • Similar Content

    • By Steve Martino
      Hello Forum.  I had some basic questions (for starters) about a report I am trying to create:
      1.  Can this type of report be created?
      2.  Can you point me in the right direction.
      I have the following tables: People connected to both Readings and Sessions with the usual primary key-foreign key relationship
      People-----------<Readings
                 -----------<Sessions
      I would like to generate a report for a person, with 1 Reading record, then Session records after that Reading record timestamp, then another Reading record, etc.
      So basically it would look like this:
                                          Person Name
                August 1 9:00:00 am (Reading record)
                         August 2 10:00:00 am (Sessions Record)
                         August 3 10:00:00 am (Sessions Record)
                         August 4 10:00:00 am (Sessions Record)
                         August 5 10:00:00 am (Sessions Record)
                  August 6 9:00:00 am (Reading Record)
                         August 6 10:00:00 am (Sessions Record)
                         August 7 10:00:00 am (Sessions Record)
                         August 8 10:00:00 am (Sessions Record)
                         August 9 10:00:00 am (Sessions Record)
       
      I've researched and used the VL technique, but didn't see an example that matched this.  I could do it with 1 Reading record and multiple Sessions records, but not multiple/multiple. 
      If it is possible, I just don't know where to start.  I've considered another TO where all the records reside, basically creating them in the order I need them for the report, but that's more like the VL.
      If I want them all to line up it would be easier, or do I just do a VL report, and as I'm appending the records, if they are Session records, just add a tab space?
      Just need some pointers.
      Thanks
      Steve
    • By Courtney
      I have a business unit within my company for whom I set up a quick time tracking database about 6 months ago based on the time tracking system that my business unit has been using for years. After their "pilot" usage, they sent me back this graphic of what they want the interface to look like. It's a spreadsheet. Really. I'm super frustrated. I don't even know where to post this. I don't know why they don't just use a spreadsheet if they want a spreadsheet.
      What I would like to do (after my top 3 completely unprofessional responses) is either refer them to an existing product that someone has already developed that looks like this OR find out if there's a relatively simple way to set up something like this in FileMaker. Did I mention this is all a "favor" that I'm expected to do at no cost, and aside from my normal workload? Right now I can't even begin to wrap my head around how to do something like this. One record with the Project, Task, Notes, and then one field per day of the week for hours to be entered?
      Grateful for any suggestions!

    • By john9210
      I am examining a demo file. The field SportName uses a curious auto entry calculation. Let[Trigger=SportCategory;""], where SportCategory is another field in the same table. What's the purpose and what does it mean? Being auto entry, I thought it only effected new records.
    • By john9210
      I have a script that is supposed to open a URL. Instead, it opens a folder on my desktop. Two script steps: Enter browse mode; OpenURL. The field that the script uses is a text field and contains the web address that starts with http://. Why should it be opening a folder? I can't find a setting anywhere to control this.
    • By AngelArs
      This should be a easy one to answer...
       
      Recently imported an excel file and all of the formatting was off. 
       
      Looking at the table, I need to select everything in a field (column) so that I can center every entry in the column. How do you do this? 
       
      I tried selecting the top entry, hold down the shift key and then select the bottom entry, but that didn't work.