Get Id show name

Discussion created by Kirk_1 on Jul 14, 2016

Ive done this several times but i'm missing something on this.


I have the relationship set up.


The layouts on the right are the PK_BolIdJoin table.


The field circled in red is the description id from the PK_BolIdJoin table. it has a drop box set up to give the id, but show the name in second filed.


The field circled in blue is the description name from the description table.


When i hit the box i get the drop down and can select a name and it populates it.


When i go to the second portal row, and select the drop down i get a description but when i select it, it populates the 1st portal row not a second portal row.