I am developing a small quotation database whose main window resembles the « Search Customers » example from « DBKit Desktop Example » (the one you get after clicking on the “separate” button, where the search results and data entry fields are on two different windows). So I have one window with one large list box with many columns.
My problem is this: my SQLite database has several tables with relational links (unlike the “Search Customers” example). I need to display information in certain columns that are in parent tables of the table displayed in the list box in order to display the values instead of the keys. Looking at the online help, I understand that I need as many connectors as I have tables involved in the relationship.
However, I do not know if DBKit is capable of doing this, nor how to proceed to display the values of the parent tables instead of the keys of the main table in the different columns of a single Listbox.
I just started using Xojo a few days ago and I’m not a development pro, unlike many of those who regularly visit this forum…
To be as specific as possible, using the example from the beginning, let’s imagine that the Listbox displays the “customers” table, as is already the case, but that the name of the city, for example, is in a parent table called “City”, which has a relational link to “customers” and a foreign key in the “customers” table. How can I display the names of the cities instead of the keys?