Creating new record Portal still shows data

[bishop7262]

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.

[webko]

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?

 

[Lee Smith]

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

[bishop7262]

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

[Lee Smith]

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.

[bruceR]

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

Edited December 7, 2016 by BruceR

[bruceR]

Some graph cleanup.

 

XFileGraphMod.pdf

 

Edited December 7, 2016 by BruceR

[bishop7262]

50 minutes ago, BruceR said:

Some graph cleanup.

 

XFileGraphMod.pdf

 

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...

[bruceR]

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.