Newbies bishop7262 Posted December 7, 2016 Newbies Share Posted December 7, 2016 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. Link to comment Share on other sites More sharing options...
webko Posted December 7, 2016 Share Posted December 7, 2016 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? Link to comment Share on other sites More sharing options...
Lee Smith Posted December 7, 2016 Share Posted December 7, 2016 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 Link to comment Share on other sites More sharing options...
Newbies bishop7262 Posted December 7, 2016 Author Newbies Share Posted December 7, 2016 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 Link to comment Share on other sites More sharing options...
Lee Smith Posted December 7, 2016 Share Posted December 7, 2016 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. Link to comment Share on other sites More sharing options...
bruceR Posted December 7, 2016 Share Posted December 7, 2016 (edited) 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 Link to comment Share on other sites More sharing options...
bruceR Posted December 7, 2016 Share Posted December 7, 2016 (edited) Some graph cleanup. XFileGraphMod.pdf Edited December 7, 2016 by BruceR 1 Link to comment Share on other sites More sharing options...
Newbies bishop7262 Posted December 7, 2016 Author Newbies Share Posted December 7, 2016 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... Link to comment Share on other sites More sharing options...
bruceR Posted December 7, 2016 Share Posted December 7, 2016 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2705 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 accountSign in
Already have an account? Sign in here.
Sign In Now