Normally, this would be a simple thing, but I've thrown a twist into it and need the community help to see if it's possible.
I have a list (table) with basic information. Key fields are CostCenter, Department. List(table) is called "CostCenters". I have a List Lookup collecting and displaying all of the CostCenter items. I have a calculated field with a lookup function. Here's were it's tricky:
The list is at the root of the site because I can reuse the List(table) in other forms and it would be convenient for me to have it in a central location. The form I'm on is a couple of levels down. The List Lookup works fine by referencing "/" and the name of the List(table). I can't seem to get the calculated field's lookup function to get the focus of this object.
Has anyone tried this before?