AnsweredAssumed Answered

Proper Relationship with ID Number

Question asked by samjs on Dec 4, 2012
Latest reply on Mar 23, 2013 by arby

I have a Student Database and I'm creating a solution to add a student to a class. In my class portal, I want a drop down list of the students names and I want the capability of auto fill.

 

I really want the relationship based on the student ID number, however, I'm having problems indexing the names so I can use them in a drop down list. The only way I can get it to work is when I build the relationship based on the student's name. How do I build a sound relationship based on the student ID number and yet have a clean looking interface without showing ID numbers along with the capability of a drop down list with auto fill.

 

Here is an example of how I want it to work...

 

Relationship.png

Outcomes