Jump to content

History of information


Learner1

This topic is 6167 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 6167 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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