Jump to content
Sign in to follow this  
bishop7262

Creating new record Portal still shows data

Recommended Posts

When I click create New Record all fields should be blank.  But my Portal, which has fields inside, pulls data from a different record.  I am not sure why it is doing this but since it is a New Record all the fields in the Portal should be empty.  Please any advice is appreciated.

Screen Shot 2016-12-06 at 10.47.18 PM.png

Share this post


Link to post
Share on other sites

There could be a couple of reasons why this is so.

How is the relationship for the portal set up - which field in the Parent is related to which field in the Child (portal) table?

 

Share this post


Link to post
Share on other sites

Why not post a copy of your file. That way we can see the Schema and we can either modify your file or suggest the changes using the actual fields, layouts, scripts, etc.

Lee

Share this post


Link to post
Share on other sites

The user: admin and password is bigsky72  

There is an Add Client button that is just New Record to create a new record

Thank you so much!

XFile.fmp12

Share this post


Link to post
Share on other sites

You have advance, did you watch the Add Client script run? I get an error that the Layout Object “infoTab” is missing?

The script doesn’t need to have the Enter Browse (You already are in Browse Mode).

You don’t want to halt script in this case.

Share this post


Link to post
Share on other sites

This is an XPOST with FileMaker Community where the problem was correctly guessed at by keywords, even without a copy of the file.

Big problem with the client ID: 34 duplicate records.

Next value for client ID: 1014

Max existing client ID: 1168

pkClientID index.png

pkClientID next value.png

Edited by BruceR

Share this post


Link to post
Share on other sites

Some graph cleanup.

 

XFileGraphMod.pdf

 

Screen Shot 2016-12-07 at 10.48.13 AM.png

Edited by BruceR
  • Like 1

Share this post


Link to post
Share on other sites
50 minutes ago, BruceR said:

Some graph cleanup.

 

XFileGraphMod.pdf

 

Screen Shot 2016-12-07 at 10.48.13 AM.png

Hi, thank you guys for all the help.  I am really new at all this.  I am not sure what I need to change to make it work...

Share this post


Link to post
Share on other sites

Oh dear.

If the solution wasn't obvious the moment the record ID problem was revealed, then you have much much bigger problems.

How did you come to be in possession of this solution in the first place? It is a rather complicated mess.

The smallest and most immediate problem is fixing the next value for pkClientID.

But you now have a lot of records that have duplicate values for the client ID; and THOSE records will have to be fixed.

And they in turn, connect to other records, such as trainer records, and THOSE connections will have to be fixed.

I think you should think strongly about getting a developer to fix this all for you and implement UUIDs, etc.

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  

  • Who Viewed the Topic

    1 member has viewed this topic:
    hutchlad 
×

Important Information

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