Reference Qualifier Use Case

[Community Alums]

Hi Everyone,

There is two table --A & B

Under table A:- Account, Business Id field is there
Under table B:- Account field is only there..

I have created the "business Id" field in table B as reference type.

Use Case: When the account in table B is same as account in table A then the business ID(for that account) from the table A should be there in table B (newly created reference field--business id)

Thanks in Advance!!

[Harsh_Deep]

Hello @Utsav JAISWAL ,

If you will use Reference Qualifier then it will give you option to choose, But if you will use BR then while saving your record it will automatically set business_id in B table.

Which option you want to follow.

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

[Community Alums]

Hi @Harsh_Deep but I need "reference qualifier" thing because I need to do the requirement for the existing records also.. 

[Harsh_Deep]

Hello @Utsav JAISWAL ,

In table A what's the field type of business_id, Later on use reference qualifier and use script include for that reference return.

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.