I have two tables that I can link together with a common field. However there is an instance where there could be more than one value in the second field. For example..
Field1 Field2 Field3
2956 362 GODNAT
2956 363 HEJ
I would like to be able to link on Field1 unless Field3 is pupulated, and then use the value in Field2 in my results.
Any suggestions would be a huge help!