In some situations, I can acess “look up” fields and display them on a screen, at other times, although the lookup frileds exist in the table, they are not able to be chosen for display in the layout section…It seems that in some circumstances its possible, in others it is not possible to see the lookup firlds at all in the layout section
Also, export does not seem to allow for export of lookup frileds - Am I missing someting?
Alan
Pay attention to whether or not the lookup is an array. If it’s an array (potential to hold multiple values), then you can’t use it somewhere that only accepts a single value. Arrays will have bubbles around the values in the data editor. If you are using a relation to source the lookup, make sure it’s a single relation.
1 Like