I ran the DDR report on the file that I was having issues with last night and the TO that appears in the relationship graph and is missing in the "Occurrences in Graph" column of the "Tables" tab in Manage Database is also missing as a TO in the DDR. When I go to define fields, the TO does show up as a related table.
I'm really confused by what I am seeing. If I duplicate one TO of a table, it will not show up, but if I duplicate another TO, it does show up as an occurrence.
The primary question in my mind is if this is a software bug or a file corruption issue? I really need to keep working & wondered if I can continue developing the file or if I need to revert to a backup? I cannot think of anything that would have corrupted the file as it is a brand new file as of the last week and has never crashed or given me other errors.
Thank you for your guidance.
That is part of my confusion as well since I was not able to re-create the problem with a file that had less tables and TOs. Below are screenshots of what I am seeing:
There are two table occurrences of the INSPECTIONS table on my relationship graph, but only one is listed in the "Manage Database" and only one shows up on the Database Design Report. The table that does not show up was created by duplication.
I meant to thank you for your response. Thank you. I really appreciated it!
Do you think I should upgrade to 10.11? I wouldn't think that using 10.10 would create this type of issue...
Newer is always better
There has been some issues with shortcuts (copy / paste / duplicate) been greyed out in FMP, which most possibly were Mac OS related and NOT FMP.
I have a solution with more than 500 Table-Occurrences based on 66 Tables in 1 File. I wouldn't know of any issue that occur when a certain amount of tables OR TO's is exceeded.
But first things first:
- do you use any PlugIns?
- could you test your solution on another Mac with Mac OSX 10.10?
Thank you again for your response.
My file definitely does not (yet) have more than 500 table-occurrences. I have never really referred to whether the TOs show up on the Tables tab in Manage Database or the DDR report before. Do you ever use these? Since I have never checked this before, the question in my mind is: "If I can see the TO when defining fields, does it matter that the TO does not appear in Manage Database > Tables > Occurrences in Graph?"
I am not using any plug-ins.
I was able to test the affected file on a computer with 10.11.3 and FMPA 14.0.4, and had the same situation....
seems that this is file related with your solution and not Mac OS.
I guess, TS will soon ask you to send in your solution for their testing.
Yes, it is good to have that ruled out. I have the 16 TOs color-coded on the chart that do not show up on the Tables > "Occurrences in Graph" column or the DDR, so I do hope that someone from FM (TS ) does reach out soon!
I didn't know that trick, thanks! We'll see if your magic works.
Thank you for your posts.
Mentioning my name in a post will automatically send me a message. :-)
If you duplicate a Table Occurrence, it should definitely show up in the Tables tab under the column "Occurrences in Graph" for the root table. Your issue is not indicative of the OS, as I am able to perform the same steps under Windows 7, Windows 8.1, Windows 10, Mac OS X 10.10.5 and Mac OS X 10.11.3 with out any issue.
Going back to "efficientbizz", do you have any plug-ins installed? If so, temporarily disable them and see if you can still replicate the issue. Also, if you have access to another machine, try it there.
If the issue is still reproducible, then I would definitely like to see a clone of the file so I can test it here and hopefully determine what is causing the issue. I have sent you a private message with instructions where to send the file.
Thank you for your response!
I mentioned previously that I wasn't using plug-ins, thinking of just this solution, but I do have two installed. I disabled them, first individually, and then both together, and that didn't change the behavior.
I am using a MacBook. I replicated the problem with the file I sent you on an iMac running OS 10.11.3 with FMPA 14.0.4 as well as a Toshiba PC laptop running Windows 7 with FMPA 14.0.4. I also verified that if I would add a new TO of an impacted table, that TO will show up as an "Occurrence in Graph" as well as any duplications of it. There are just certain TOs that somehow never got "linked" when they were created (by duplication it seems) and then any duplications of the TO never get "linked" either to be able to be displayed as "Occurrences in Graph" or on the DDR.
I sent you an email with the affected file & look forward to hearing back from you.
I received your file. Thank you.
I noticed in the Relationships graph that the tables in question are in Italics, which means you are linking to another file's table; not the current file. If you hover over the top left corner of each italic table, you will see you are linked to a file, even if it is the current file. If you hover over the top left corner of a non-italic table, you will see the Data Source set to <current file>.
Changing these externally linked tables to current tables will then display the table occurrence in the Tables tab "Occurrences in Graph".
Good morning TSGal,
Thank you very much for your fast response. The file the tables are in is the one it names as the source table, "SEC Data". (I missed the difference between the others which specify <current file> as the data source.) In the external data sources, I notice that it does list SEC Data as a source, even though that is the file itself. I definitely did check what the source table was, but didn't even think about it looking at an "external data source" of the file itself. I have no clue how that external data source of the file itself got there, but you are absolutely correct. I'm thankful that this is the problem and it is not a file corruption issue or bug.
Thank you for your time and help. Lesson learned!