Update one form automtaically upon fields on another

[Dazzy]

Hi Guys

See the attached pic, I would like to update the Previous Education tab based on values on the Courses tab.

The aim of this is to keep a clients previous education upto date in order to append it to a CV etc.

Thanks for any help.

Regards

Gary

 

[David R]

Do all Courses gain the client a Qualification? If not you'll want to have a way in the Course table to flag the ones that do.

Basically what you're looking for to run that tab is a Totals Query, I believe. You want the latest (Max(DateAchieved) version of any qualifying class, the Employee information (name and/or ID, your choice), and the course name and level. because it's a Totals Query it will be read-only so your header will need to be updated, but all the information can be input on the Courses tab, looks like.

 

[Dazzy]

Hi David

Thanks for the reply, yes all courses if completed will have a certificate attached, so therefore I am thinking the logic will be if Completed is checked and Date Cert Rec is not null will trigger this event. Does that make sense?

 

[David R]

You don't need any events. Your Previous Education query will look at the Courses table and can figure out what is the most recent/highest certifications.

If you post your table structure someone can help you write a query, but if you haven't played with Totals Queries before they are very powerful and I encourage you to experiment with them a bit.

 

[Dazzy]

Hi David

Sorry about delay in replying got side tracking with something else.

I have attached an image showing the structure of the tables, have to confess queries have always been my weak point.

Thanks

Gary