Suggested Values based on a Table that is NOT RELATED

Luis_DfG
Participant V

[CONTEXT]

I’m working in an APP for the Education Field.

Our Teachers can give sessions in [1] OUR OFFICES OR [2] THE CLIENT’S OFFICE

For that reason we added a field call “Session Address”.

I tried to SUGGEST VALUES based on the list of Addresses in my Office Table.

[PROBLEM]

I could not pull the list of addresses from the Office Table.

I believe the reason for that is the I currently don’t have a REF column between the SESSION and the OFFICE tables.

But I don’t need or want one because by doing so I would need to add a new column (Office ID) to my SESSION table but that is not always true since we can dictate sessions at our client’s office and we don’t wan’t to save that information in our OFFICE table.

[QUESTION]

It is mandatory to create the relationship between the table in order to SELECT the list of Offices?

It doesn’t make much sense that I need to force a relationship between 2 tables just to consult information.

I have got around this problem by creation a manual LIST but this in unpractical in case we add new offices to our OFFICE table.

Solved Solved
0 5 378
1 ACCEPTED SOLUTION

Then you don’t have a table or slice named Office.

View solution in original post

5 REPLIES 5

Steve
Participant V

Nope.

Nope.

This is an invalid SELECT() expression:

SELECT(Office[officeAddress])

SELECT() needs at least two arguments:

Instead, try just:

Office[officeAddress]

Luis_DfG
Participant V

Hi Steve,

Same result.

@Luis_DfG
Have you imported that Office table into the app?

Then you don’t have a table or slice named Office.

Luis_DfG
Participant V

Silly me…

Thank you.

Top Labels in this Space