In Xano, a relationship between database tables is created using the data type table reference.
Relationship data display A table reference is typically just an integer referencing the unique ID number from the table of the referenced record. However, often times it's helpful to visualize what the reference represents beyond just a ID. With Xano, you can see the fields of your referenced record that are important to your use case.
Auto-complete relationships When entering a reference record, Xano presents you with a drop-down menu. The menu provides you with the recently added records from the table you are referencing. Additionally, there is a search bar where you can search for the id number or any of the displayed field values. You can quickly navigate using the keyboard arrows and enter key.
Choosing which data to display By default, Xano will automatically display the first text field and the id field of the referenced table record. However, you can easily customize which data you'd like to be displayed in your table reference.
In the parent table (or the table being referenced), click the menu icon in the top right (three dots), then select Auto-Complete. In this example, the parent table or table being referenced would be the merchant table.
After selecting Auto-Complete, the settings will open up. Click customize in order to customize the display of the referenced data.
You can add multiple columns, reorder the columns displayed, and remove columns from the display.