Not sure how you are setting this up and what tables are involved.
Is Alan already assigned to Class A or is this the first time assigning him to the Class?
A screen shot of your graph would be helpful and a copy of the file you are working with would be even better.
It sounds like you have a Class table and a People table that you are joining in a Students table. This is fairly easy join table situation, but may not really be what you want.
The Student table needs a StudentIDpk, PeopleIDfk, and ClassIDfk. Realte the fk fields to the pk fields int he other tables. You can now easily display the actual values from the other tables on the layout or set new fields in the Student table with a LookUp value.
Thank you Stigge. But there is not what i am trying to do.
Attached is the file i created. I would like to have the height field automatically be filled.
You have too many tables going on. Here is your file with a few small changes.
Using Class field as a value list only
Only using one table to pull in the student name and height
The portal on the left is displaying the actual data from the student_class table and the portal on the right is displaying the data set in the join table via lookup. How you store it really depends on what you are trying to do with the data in the end.
Thanks tom, but i can't access the link.
Direct Dropbox links are not clickable I this community. You need to copy and past the exact text in the post.
If yo kick in your Dropbox link you will get a similar error.
The file is there.
Thank you Tom. I have decided to use look up function.