Jump to content

Disappearing field information


printz
 Share

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

Recommended Posts

I have a database that lists Cruise Lines as a drop down value list. When I select a particular cruise line, all the ships for that cruise line appear in a field for ship names. When I select the ship name from the value list, it appears as the input in that field.

Now, the problem. The ship name for all the records in the database disappear and becomes blank sometime further down the road. I cannot find the trigger that causes the information to disappear.

Does anyone have any idea where I can look to correct this problem? Thank you in advance.

Link to comment
Share on other sites

Do you mean all of the ship names or just all cases of a particular ship name? I'd be surprised if your problem is related directly to what you've described. Look elsewhere in your solution.

FWIW, I have had a vaguely similar thing happen.

Someone used a child field on a basic working layout. i.e. Master::Name

Some other one, just blanked that field on the layout. Bingo! that Name in the Master is no longer there and any other records looking it up show a blank. (I inherited a DB where child fields were used quite a bit in this way. The blanks were easy; it was the changes that caused havoc, until I fixed them all.)

Link to comment
Share on other sites

All of the ship names disappear from every record. I have it set up so the Cruise Line field is a drop down from a value list. Then depending on the Cruise Line selected, only the Ships for that cruise line appear for selection in the Ship Name field. This was created by using a value list and Include only related records starting from Cruise Line.

Everything looks just fine, then maybe a day or two later, for some unknown reason, all the ship names in every record disappear. The Cruise Line fields are still there.

I hope that clears things up a bit. Does that qualify for a Child FIeld? I am not familiar with that term.

Link to comment
Share on other sites

I do not think that your initial record formation routine is the problem here. The values stick around for awhile and then disappear. They probably just would not stick in the first place if it was at that part of the program.

Take a look at your reporting. Some times there is a lot of processing going on to get a report out. Somewhere in that processing may be an errant script step that is deleting the values.

If it was sets of records disappearing and there were related fields there, I would suspect a cascading delete in action.

Good luck

Dave McQueen

Link to comment
Share on other sites

Ive had issues with unstored calcs... where they wouldn't calculate properly and a field value had to be re-entered (one of the fields used in the calculation in one record on that table).. Only if the app was closed then re-opened - calcs would blank. Very strange... But still, i've never had actual data blank out?

Link to comment
Share on other sites

Printz,

"I hope that clears things up a bit. Does that qualify for a Child FIeld? I am not familiar with that term. " Yes it does. (Don't pick on me Soren!) A child field is effectively a field referenced via a relationship. From your description, that does not appear to be the problem.

As someone else suggested, you are probably emptying the field somewhere else. Check all of your scripts. Do you have a field anywhere with a similar name?

Link to comment
Share on other sites

I have reviewed all my scripts and cannot locate anything that could possibly delete just the ship names.

In regards to David McQueen, could you explain a little more in detail your comment "Take a look at your reporting. Some times there is a lot of processing going on to get a report out. Somewhere in that processing may be an errant script step that is deleting the values."

Maybe that would give me a little insight.

Thanks everyone for your help.

Link to comment
Share on other sites

Is the file networked? Do others play with the data? If so, do they know what they're doing?

Do you do any (scripted) finds for empty ship names?

Has the data really gone? A carriage return added at the front of the data works wonders; the data 'disappears'.

I have had the text colour change to white for no apparent reason. (No, I didn't believe it either but it happened.)

Do you re-enter all of the missing data?

How about putting in a calc field to get a timestamp when the data vanishes? It might point you somewhere.

Link to comment
Share on other sites

This topic is 5591 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
 Share

  • Similar Content

    • By Matthew R White
      My database is hosted in the cloud with Filemaker server and I have 12 FileMaker Pro users.
      I need help with a 2 page pdf document that gets generated with information for each client, sending that via API to docusign, and building a Docusign link that I can send to a customer to click and complete if they choose to with Docusign.
       
    • By omnia
      I am a canadian and I work with fmpAdvanced.
      if you find a solution, I'd appreciate you contacting me.
      <reply by private topic>
      I am looking at a solution for inventory.  One important request is that they need to be able to calculate the inventory for previous dates.  E.g. the beginning of the quarter compared to today or this day last year.
      My thoughts so far to be able to do this is to have an article file and a stock movements file, all values and quantities of stock will be held in the movements file.  Basically the last related record will be in the movements table will be current value, but we can also find the last related related record based on any date. 
      Will this be a fast way to calculate or slow?  I don't want to start and then find things slow down on me too much.
      After this I will also need to be able to age the stock.  
    • By wedgeman
      We are working with a medical non-profit working in Latin America, running on much older hardware.  Seeking older individual or group/site license seats of FMP & FMS 13, 14, or 15.
      We need a bunch.  We could buy site license seats, or simple 1-off licenses.   
×
×
  • Create New...

Important Information

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