Trying to find a way to join values in two separate columns into a third however one of these is a lookup field to a second list and as I understand you cannot do calculations on lookups without using SharePoint Designer.
For reasons unknown to me (and which cannot be changed) SharePoint Designer cannot be used with the site in question so wanting to see if there was an alternative solution maybe using InfoPath.
I have the following lists:-
ActionName : Single Line of Text
ActionNumber : Single Line of Text
SubActionName : Single Line of Text
SubActionNumber : Single Line of Text
RelatedAction : Lookup [ListActions:ActionName, ActionName:ActionNumber]
SubActionFullRef : Calculated (Ideally appending the SubActionNumber to the ActionNumber]
Is there a way to calculate ‘SubActionFullRef’?
Any pointers/ideas greatly appreciated.