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

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.

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.

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.

The simplest way is to use a portal. Add new data by filling the last (empty) portal row.

EventData.fp7.zip