It's been a while since I used FM and I'm a bit rusty. I couldn't find this question in the forum anywhere, please help.

The database I'm creating stores training sessions (including fields; "session ref" a serial No, "session name")

Another database called trainers (including fields; "trainer ref" a serial No., "Trainer Name")

And another database called Trainers Sessions list (including "session ref" and "trainer name") which holds a list of all the trainers at every session.

Eg; Session Ref - Trainer Name.

1 - Cathrine Bell

1 - Simon Bowman

2 - Jason Horton

Shows that Cathrine and Simon were at session 1, and Jason was at Session 2.

When you add a new session you select which trainers were present in a portal which you do from a drop down list of all the trainers.

How can I make it so that if i change the name in "Trainers:Trainer Name" field, it automatically updates in "Trainers Sessions list:Trainer Name"?

Thanks for your help

Instead of using "trainer name" in the Trainers Sessions list, why not use use "trainer ref" instead.

Edited November 16, 200619 yr by Guest
Rephrase

because that means you have to select which trainers were present by their reference. And most users wouldnt know which trainer "1" was.

I could put in the pop-up menu a second field, but since it should be sorted by trainer the list might look like:

4 Jason Horton

1 Simon Bowman

3 Cathrine Bell

And that not only looks stupid, but also if it stores the Trainer Ref, it means if you want to know which trainers were present at a previous session, you could only see their ref, and would have to look-up who that ref is.

Is there any way a user can select by trainer name, and it store the trainer name, but auto-update if the trainer name is altered?