Hi

i'm looking for knoda's users

i use knoda for adding lyrics in amarok database
i need to create un form with a subform
i have no problem for
creating form and sub-form
insert subform in form

but i can't create relation beetwen form and subform

the master table is named "tags" with fields :"artist" and " lyrics" the "tags" table is joined with "artist" table ( fields : id name"

help i'need somebody

dominique

bonjour
je cherche des utilisateurs de knoda
j'utilise knoda pour rajouter des lyrics dans amarok
je voudrais faire un formulaire avec un sous-formulaire
je n'ai pas de pb pour
créer le formulaire ,le sous -formulaire
inserer le sous -formulaire dans le formulaire
mais je merdoie lamentablement pour lier les 2
*ça me fait d'autant plus rager que j'y étais arrivé avant de faire face à un crash de l'ordi et donc une réinstallation

j'ai deux tables qui interviennent
la table maitre est nommée tags avec en autres un champ artist et un champ lyrics le champ artist est lié à la table artist (id name)

The best way to create a relationship would be to have an artistID field in the 'tags' table. You can then do joins with a SQL command that includes 'WHERE tags.artistID = artists.artistID'.

Knoda is a good SQL database front-end, but it pays to really understand how SQL databases works. Then you will know what the software tool should and shouldn't be able to do. I have MySQL Administrator, Query Browser and Knoda installed on my machine, and I find Knoda to be excellent for directly working with database tables. Neither of the MySQL AB apps let you easily directly edit a database tables field contents. Knoda does.

One area where it does fall down is allowing edits to BLOB fields, which can be good for storing arrays. In the Windows world, MySQL Front (the early version) was the all time best database front-end I have ever used. I still waiting for a Linux front-end to approach its user-friendly effectiveness.