table ref fields not working

System8

When I try to reference my organization table from another table with a table ref field it does not work. The items provided are not the organizaiton.id's and there are no descriptors provided either to see what field it is actually referencing. The screenshots below show the issue and it is across my entire instance. At this point I can not build any more endpoints that call up the organization table or utilize it as an add-on because the reference field links to arbitrary data.

The first screenshot shows a sample table trying to reference organization.id = 9

The second screenshot shows how the options for selecting the organization.id are not the typical options with a descriptor.

The third screenshot is the results of a query all from the table in the first screenshot. ID = 9 was selected but it returns id = 29

Chris Coleman

Hi, @System8. Can you check the Auto Complete settings on the Organization table?

System8

@Chris Coleman, that was the issue. I must have been playing around with that table's functions when I first set everything up as that was one of my first tables and never changed it back. Either way, thank you for pointing me in the right direction.

Chris Coleman

No problem!