Suggested Values based on a Table that is NOT RELATED

[Luis_DfG]

[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.

[Steve]

Luis_DfG:

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

Nope.

Luis_DfG:

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

Nope.

This is an invalid SELECT() expression:

SELECT(Office[officeAddress])

SELECT() needs at least two arguments:

help.appsheet.com

SELECT()

Gather column values from row in table or slice

Instead, try just:

Office[officeAddress]

[Luis_DfG]

Steve:

Office[officeAddress]

Hi Steve,

Same result.

[LeventK]

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

[Steve · Accepted solution]

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

[Luis_DfG]

Silly me…

Thank you.