July 12, 200718 yr Hi Guys, Im stuck with this calculation (even if it is one). I have a 'street location field' which is a drop down - from a merged field containing the street & suburb into the one field. This is created via a portal. I have a design run sheet that displays the locations etc that was put in from the portal. But In the run sheet, I dont want to display the 'merged field' instead just showing me the street (without the suburb). How do I go around this??
July 12, 200718 yr Enter the data using separate fields for Street and Suburb. Then where it's desirable to have them combined, either merge them on the layout (using merge fields), or use a calc that concatenates them.
Create an account or sign in to comment