Of course related data can be displayed. More than one way to accomplish.
1. include as column in combobox or listbox and expression in textbox reference combo/list box column index: =[comboboxname].Column(x)
2. include lookup table in form RecordSource and bind textboxes to fields, set as Locked Yes and TabStop No to prevent edit
3. DLookup()