There are 3 tables, Projects, Claims and Task. One Project has many Task. One Claim has many Task. I would like to see all Task in one report. Currently I have a column for Claims and a column for Projects. Though, if its a Project, the Claim field is always blank, and vice-versa. Is it possible to have a formula to combine them into one field so it shows Claim or Project name depending on which one is still filled in but still maintain its relationship property where if you clicked on it you still are linked you away to the Claim or Project it was associated with. Sorry if this was not clear.