If I create a database with tables having relationships (that is what relational databases are for, surely) how does Kexi handle this in forms? In particular where I have a column in one table that has to be selected as a value from a column in another database how is this done in Kexi?
Basically what I want is a drop down list of values from one table to provide the value to be inserted in the other table.
If I understand what you want to do I think it is done the Table Design view. If tables are not yet connected by Primary Key/Foreign key relationship, set that up in the right most tab in the right panel (just to right of Properties). There you set up not only the record (data) source table, but the bound column (the corresponding key) and below that the Visible column is which field in that table you want to see in the drop down. I am brand new to this but since no one had replied and I did it that way today, I hope it works for what you have in mind. In my case, I was saving only the integer ID (key) and the ‘visible’ column option makes it clear what ID from the table you are choosing. Used this with a combo box (couldn’t find a List box only). I’m not sure if there is a way to do this to store a full text field, but it seemed to work to store the index after properly displaying the chosen “visible” field. Very simple. Might experiment with “Bound column” options later.