Circular References

[BlueTech]

Hi,

I have a Tasks table with two reference columns: [Customer] and [App].

Each App belongs to a single Customer.

I want:

• When I select a Customer, the App should auto-fill.

• When I create a Task from an App, the Customer should auto-fill.

But whenever I set an expression like this in the Customer Initial Value:

IF(ISBLANK([Customer]), [App].[Customer], [Customer])

(or similar SELECT/LOOKUP versions)

I get a circular reference error because Customer depends on App and App depends on Customer.

What is the correct way to auto-fill one field from the other without causing a circular reference, and still allow the Customer to be manually selected when no App is chosen?

I would appreciate any help.

[ThiagoNilbox]

Try using this in the field valid if the [APPLICATION] column:

SELECT(Applications[ID], [Client] = [_THISROW].[Client])

[Steve]

Initial value expression for Customer:

[_THISROW_BEFORE].[App].[Customer]

To prevent the user from changing Customer when the task is created from an app, consider also setting the Edit? expression for Customer to:

ISBLANK([_THISROW_BEFORE].[App].[Customer])

[BlueTech]

Thanks Steve! That worked.