You can use INNER JOIN or LEFT JOIN in SQL query to retrieve data from several tables.

If you specify what query you use and provide structure of tables, we can help to modify the query.

Regards,
ARI Soft

Thanks.

For the primary tiny table:

Column 3 should retrieve values from DB table Konstruktionskategorier (integer correspond to id in table Konstruktionskategorier)

For the secondary tiny table:

Column 1 should retrieve values from DB table teknologilev (integer correspond to id in table teknologilev)
Column 8 should retrieve values from DB table Konstruktionskategorier (integer correspond to id in table Konstruktionskategorier)

Regards,

Magne.

Send SQL dump of the tables by email please.

Regards,
ARI Soft