I have two tables, people and users. People has an ID(Primary Key), first name, and last name field. Users has an ID(Primary Key), Person ID(Foreign Key - related to people primary key), username, and password. The foreign key reference on users is shown as the first name and last name from the People table concatenated (based on foreign key reference), which is fine for this example but is it possible to have just one field of those fields show, i.e. just the first name? Thanks.