Newbies Dommi29 Posted April 4, 2016 Newbies Share Posted April 4, 2016 Hello, I am beginner with filemaker and I got a database from a collegue. In the database we create reports and the report number serves as the link to the different tables. The report number is a consecutive number. Now I have the problem, that I created the reports not in a chronological manner because I did not have all data available and thought I could adjust the report number afterwards. But when I change the number all fields are set on blank again as they are linked to other tables over the Report number. Is it somehow possible to rescue the database or do I have to start over again in the right chronological order? Thank you Link to comment Share on other sites More sharing options...
webko Posted April 4, 2016 Share Posted April 4, 2016 I would create a new ReportNumber field that is not used in any relationships, and then populate that in the correct order. You may need to edit the layout(s) to display this new field rather than the old one. Link to comment Share on other sites More sharing options...
Newbies Dommi29 Posted April 5, 2016 Author Newbies Share Posted April 5, 2016 Thank you for the quick response, seems like it's working! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2964 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