I have two tables linked. My left table is my main table. I have link from Left to right with left outer not enforced.

when I move the fields from my left table into my report they show their id number that corresponds with the name in the right table. But when I use this formula
if (isnull({datatel_undergraduateapplicationforadmissionExtensionBase.datatel_parent1collegeid}))
then "No School Listed"
else
if {AccountBase.AccountId} = {datatel_undergraduateapplicationforadmissionExtensionBase.datatel_parent1collegeid}
then {AccountBase.Name}

The school name is not showing. I do get the "No School Listed" if the field is null, so that part is working. Not sure where I am going wrong on this one. It is another one of those "head banging on the desk" moments, and I am starting to get a mark.
Thanks for any help
Kevin

Still not getting the school name to display - just gives a blank space. i know that there should be a name there because I am also listing just the school id to make sure that something should be there. I thought is was a linking issue, but every time I try to change it I end up losing some of the kids that are associated with the account.

Thanks
Kevin

It was, but I changed my joins from left outer to right outer and that cleared up the issue.
If I move the field into the report I see the field number from the main table, but when I put a formula into the field to display the name, then I do not see the name like I should.
I have checked to ensure that there is a matching field number in each table.

{datatel_undergraduateapplicationforadmissionExtensionBase.datatel_parent1collegeid}
is the field name from my main table. The name for the school comes from my Account Base table and is
{AccountBase.Name}

If I just place the name in the field it does show, the problem is that I have two fields parent1 and parent2.

Thanks

for each student we list each parents information. If there is no info, then nothing is displayed. Each parent is listed separately in the main table and each as a college id number.

What I want to be able to do is display each parents school information. If one is null, then display the "No School Listed" If both are null, same message for each. I tried creating a formula for both, but kept finding that the school name would not display properly.

If I place the {datatel_undergraduateapplicationforadmissionExtensionBase.datatel_parent1collegeid}
and {datatel_undergraduateapplicationforadmissionExtensionBase.datatel_parent2collegeid}
fields into the report without a formula, then I get the id number for both. It is when I try to display the corresponding name for the id number, then I don't see anything.

Thank you so much for all your help by the way.
Kevin