Updating a field instantly when a record in a related table is added, help please.

[HPage]

I have a database with a list of students, and their employment history. The employment history is stored on a table and I have a portal on the student layout that shows the employment history (I also use the portal to add new employers to the history). The last record in the portal is obviously the current employer.

I also have a list layout which lists all the students and their current employer. I am having trouble getting the field to show their last (current) employer.

I created a button with a script that updates the field and it works, but how do I get the field on the list layout to update the moment a value is changed?(In other words the moment an employer is added in the portal on the students layout)

The problem with the button is that it has to go through every record and updates it (even if nothing new was entered.) And I have 12000 records, so it takes quite a while. Would be MUCH nicer if the update could be "live". Help would be greatly appreciated.

Thank you.

Edited November 9, 2006 by Guest
removed link

[mr_vodka]

If the calculation of Last (History::Date_Employ) is correctly on the parent side then on your list layout, if you put that calc on it, it should work for you. Are you sure you arent missing something?

[HPage]

I did it that way with an auto enter calculation, but It wont work. But when I use a button that with SetField[students::Emphist; Last(Employment::ClientID) it works. Why wont the Last(Employment::ClientID) calculation work with auto enter?

[mr_vodka]

Take a look at this post.

[HPage]

I used an auto enter field with the calculation option. I should have used a calculation field... It works perfectly now... Much easier than I thought. Thanks for the help though.