Russian Qt Forum

        modelFlats = new QSqlRelationalTableModel( this );
	modelFlats->setTable( "tbl_flats" );
	if ( !modelFlats->select() )
		{
			return ;
		}

        streetIdx = modelFlats->fieldIndex( "street_cod" );
	modelFlats->setRelation( streetIdx, QSqlRelation( "tbl_street", "street_cod", "street_name" ) );
	cdi.comboStreet->setEditable ( true );
	cdi.comboStreet->setModel( modelFlats->relationModel( streetIdx ) );
	cdi.comboStreet->setModelColumn( modelFlats->relationModel( streetIdx ) ->fieldIndex( "street_name" ) );
	cdi.comboStreet->setCurrentIndex( 0 );
           cdi.comboStreet->setAutoCompletion(true);

   modelFlats->setFilter( "flats_cod = " + FlatsCod );
   QSqlRecord rec = modelFlats->record( 0 );
   cdi.comboStreet->setCurrentIndex( cdi.comboStreet->findText( rec.value( streetIdx ).toString() ) );
      

CREATE TABLE BUILDING (
    ID          INTEGER NOT NULL,
    STREET_REF  INTEGER,
    NAME        VARCHAR(32)
);


CREATE TABLE CITY (
    ID    INTEGER NOT NULL,
    NAME  VARCHAR(32)
);


CREATE TABLE STREET (
    ID        INTEGER NOT NULL,
    CITY_REF  INTEGER,
    NAME      VARCHAR(32)
);

CREATE VIEW BUILDING_WITH_CITY(
    CITY_ID,
    NAME,
    STREET_ID,
    BUILDING_ID)
AS
select city.id as city_id, building.name, street.id as street_id, building.id as building_id
from building
   inner join street on (building.street_ref = street.id)
   inner join city on (street.city_ref = city.id)
;