Avoiding circular definition.

[XDmocra]

Hello,
I'd like to create a form containing multiple columns referring to the same item.
For example, I have [Desk] (ref. to Desks_Table) column and a [DeskNumber] column.
Some employees may remember the desk name and some may remember the desk number. 

The idea is to allow users to input either one of those in order to complete both. Unfortunately, no matter what I try (initial value, formula in a virtual column,...), I keep getting the ("Circular definition") error.

Do you have any idea on a workaround?

Thank you all in advance.

note: in reality I'm using 3 fields [Desk], [DeskNumber] and [DeskAddress] but the problem is the same.

[AleksiAlkio]

It sounds it would be better to arrange one additional search column for this purpose. The user can then fill either the desk, desk name or desk address and that will prompt the correct desk ID.

[XDmocra]

Hello,
thank you for your quick reply!

So if I understand this correctly:

In my Desks_Table:
[DeskID] [DeskName] [DeskAddress] and I add [Computed_DeskSearch] witch is a concatenation of [DeskName]," - ", [DeskAddress] and use it as a Label.

Then in the table i want multiple input options, I put only one, Type ref and thus using that computed value containing all information in one.

Did I get this correctly?
So if I understand correctly there is no way to have multiple input options to compute a single ref column?