Jump to content

relating by reference, but showing names!


Ninja
 Share

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

Recommended Posts

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

Link to comment
Share on other sites

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

Edited by Guest
Rephrase
Link to comment
Share on other sites

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?

Link to comment
Share on other sites

This topic is 5793 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
 Share

×
×
  • Create New...

Important Information

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