Creating a table to table relationship with specific reference field

Question

We have already created a table with all of our AE's and Project Requests. Now we need to connect them (each AE has many project requests), but the reference field we want is not showing up as an option. Why could that be?

quickbasecoachd · Answer

I have seen this happen when the reference field has already been used on a different relationship.

I just create a mirror field called like
[Related AE Mirror]
with a formula of [Related AE], and then base the Relationship on that field.

Forum Discussion

Creating a table to table relationship with specific reference field

1 Reply

Related Content

Multiple reference proxy fields help

Same reference field, different selections within the form

Create a formula duration over 5 years

Many to Many Relationship, Auto Fill Reference Field

Relationships functional question

Recent Discussions

Formula to get the roles of everyone in people table

ToUserList display in order of formula entry

Pipeline help

Empower Discussion

Form rules for checkboxes and buttons on new form