Learner1 Posted August 2, 2007 Share Posted August 2, 2007 Hello, In the system I am creating I need the user the user to be able to see the history of information while creating new data. For example, for a given event, he has to update the probability and the impact each year. so I need him to be able to see the previous info in the new form and create new records. Previously the company was using a word table with last year's info and current info.I searched all the documentation I have for filemaker but can't find anything about this. Does anyone have any suggestions? Thanks in advance Link to comment Share on other sites More sharing options...
David Jondreau Posted August 2, 2007 Share Posted August 2, 2007 You can create a relationship between the a table and itself. It's called a self-join. For instance, in the relationships graph, you create a second table occurence of Events and relate the two to each other by EventID. Events::EventsID = Events2::EventsID Then you make a portal on the Events layout that shows records from the Events2 table. This will show all related Events including the one you're looking at, you can change that by modifying the criteria for the relationship. You'll probably want to sort the relationship descending by DateOfEvent. Link to comment Share on other sites More sharing options...
comment Posted August 2, 2007 Share Posted August 2, 2007 Without knowing more specifics, I would say put the changing information in a separate related table. Having a table where each event is a unique record is an advantage not to be given up easily. Link to comment Share on other sites More sharing options...
Learner1 Posted August 2, 2007 Author Share Posted August 2, 2007 Thanks to both of you. The changing information is in a seperate table but I have no idea how to make the layout show the old data and allow for inputing new data. Link to comment Share on other sites More sharing options...
comment Posted August 2, 2007 Share Posted August 2, 2007 The simplest way is to use a portal. Add new data by filling the last (empty) portal row. EventData.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6246 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