Thanks a lot sparrow for the steps and insights.
I'll do these asap.

Yes I had found the xml files of Persona and converted them to csv but I'm not familiar with it yet so I couldn't use it.
attachments-us1-cloud-deskpro-com.s3.amazonaws.com/files/962/294/293258JMXAWQTNQRXRMYY0-Persona-Extra-Samples.zip
convertcsv.com/xml-to-csv.htm

Get back asap with next progress!

Jean,
Sorry, I just got this mixed up.
I have corrected the text below.

We used Image in this project.
As for DBImage, the main obstacle was its functionality, which is different from other components.
For example, correct interception of image loading for recording in the database, similar to Edit and Memo.
Essentially, the DBImage component is an enhanced Image. Therefore, we used Image and attached some functions to it in the script.
If you need a Save button to save a picture from a storage location to another location you need, adding it is no problem.
In any case, there is room for creativity in a test project. Add Tree Search, ComboBox for Styles. Apply the color as Derek suggested.
A picture for a musician. It is possible to download and view multiple images for an album (requires database modification).
I think that at this stage it is necessary to divide this topic into two so as not to disturb Frank with other conversations. If you have any new questions or help, please create a new topic.
If any difficulties arise, I will try to help.

Frank,
You can find a description of the base structure for the tree and an example at this link. http://myvisualdatabase.com/help_en/pro … ings1.html
As far as I understand you, you want to make some kind of analogue of Persona.
You don't have enough database knowledge yet.
You have taken on a rather large project.
Start small. Don't try to do everything at once.
Let what you drew remain. Start first with the main tree in your project. Get the output to work.
Then Enable One Edit field. Let's say Name (its output in Edit , its editing and saving to the database).
At this stage, through trial and error, you will begin to understand how the components interact with each other.
The next step is to connect the ComboBox. Etc..
And of course read the forum, books, websites. Use examples of solutions from forum members.
Persona uses XML in its work. It stores reference books, saved characters, and projects in this format.
As you gradually expand your program, you will add data from XML to SQLite tables. Now your database is all in one pile.

Thanks Derek for that example.

I came that far with my project in attachment:
the project (with the script of interest)
paste.c-net.org/StanleyTower
the db files
paste.c-net.org/ConnellYummy

I'm not sure about how to get  forward with the script as
my database design skills are rudimentary and I doubt the schema is correct but it seems
I can't make more connections as per given by the Persona model.

Could anyone point me toward next recommended steps I should be taking
in order to display the database characters names in the treeview?

I should be able to proceed from there with the tags filtering, likely by using a a 2dn form
as with the Persona model.

Thanks again!

New mod, Drag and drop images are now supported.

A simple way to 'avoid' the use of a button is to actually still use a button with either the 'search' or the 'sqlquery' function but then hide it. 
Then use the 'incremental search' function (see screen shot in the attachment).  This is a 'no script' option.
Derek.

I found the SQL Query reference in the guide under the button menu
(which function requires a tablegrid object for displaying the output rather than my previously used memo3):
myvisualdatabase.com/help_en/SQLquery.html
(I had been looking for the SQLQuery documentation using the SQLQuery keyword, which returned nothing, but SQL Query did).

Then got the SQL syntax corrected from this great resource and pointer post:
sqlitetutorial.net/sqlite-subquery/
myvisualdatabase.com/forum/viewtopic.php?pid=45037#p45037

SELECT  mname
FROM musicians
WHERE musicians.id = (
   SELECT id_musicians
   FROM Alb_info
   WHERE Year = '1978'
);  

It now outputs as expected:
ibb.co/D1GTHsr
ibb.co/kQkHRKV
ibb.co/mtGrFzN
ibb.co/p2w9NSf

The latest script:
https://paste.c-net.org/RapportHendrix

Sparrow, you mentioned the use of SQLExecute function.
Is there some way to output the SQL Query result in a Treeview when using a script with the SQLExecute function?
Avoiding the use of a button? I'd like to display the output straight from clicking the "MUSICIANS" menu if possible.
If so, do you know of some sample or example I should be referencing?

Thanks again for your remarks.
Regards,
Frank

The best tutorial on MVD is this forum.
You are using the "SQLQuery" function and not the "SQLExecute" function. Each of these functions has its own syntax and return data.
The SQL language in MVD is standard for SQLite and MYSQL.

The SQLExecute function is quite simple and is only needed to retrieve one field and one record.
The SQLQuery function allows you to retrieve multiple fields and records.

For images you need to use a different path.

I'll try to make an example

Based on your excellent project, I tried to add an additional object: the album cover.
In the Alb-Info table, I therefore created an Image field called Covers.
When in the OnExit procedure which saves all the entries, I implement this code:

if (Sender is TdbImage) and (TdbImage(Sender).TagString <> StrToMD5(TdbImage(Sender).Picture))
   then
   begin
     if SQLExecute('SELECT count(id) FROM "'+TdbImage(Sender).dbTable+'" WHERE id_musicians = '+Form1.TreeView1.sqlValue) = '0' then
       SQLExecute('INSERT INTO "'+TdbImage(Sender).dbTable+'" (id_musicians) VALUES('+Form1.TreeView1.sqlValue+')');
       SQLExecute('UPDATE "'+TdbImage(Sender).dbTable+'" SET "'+TdbImage(Sender).dbField+'" = '+TdbImage(Sender).sqlValue+' WHERE id_musicians = '+Form1.TreeView1.sqlValue);
       Form1.Label7.Visible := true;
       TdbImage(Sender).Tag := 0;
       TdbImage(Sender).TagString := '';
       Timer(1000);
   end;

I get an incompatibility message between String and Picture.
I guesse this problème stands here : StrToMD5(TdbImage(Sender).Picture))
There is no way to resolve this anomaly. I ask for your help
How convert String and Picture ?
thanks in advance
Sincerely
J.B.

I've looked and done some tests with Derek's treeview music m.zip script version from sparrow.
Here is my latest modification:
paste.c-net.org/GatherLimited

In summary, I added a GroupBox3 to the form and tried modifying the script
by adding a SQL command to the top level tree node { to execute when clicking the "MUSICIANS" treeview Menu }.

The idea would be to ouptut the Musicians names matching the SQL command inside the
Memo3 field in the GroupBox3, upon clicking the MUSICIANS treeview entry.

I tested the following query which returns a " not enough actual parameters at 38.18" error:
ibb.co/JRmPpZK

         SQLQuery('SELECT mname FROM musicians WHERE musicians.id in (select Alb_info.id_musicians from Alb_info where Alb_info.Year = "1978")');
         { SQLQuery("SELECT musicians.mname FROM musicians, Alb_info WHERE Alb_info.id = '1978' "); }
         { SQLQuery('SELECT id_musicians FROM Alb_info where Alb_info.Year = "1978" ');  }
         { SQLQuery('SELECT * FROM musicians'); }
         Form1.Memo3.Text := Results.FieldByName('mname').AsString;

I also tested the other commented out SQL commands above which return the same error.

I could not find a solution or helpful suggestion online to this issue despite finding some good resources
stackoverflow.com/questions/10829812/sql-query-where-value-of-another-table
codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
stackoverflow.com/questions/5446778/select-from-one-table-matching-criteria-in-another

Is there some specific SQL syntax to MVD I'm missing? If so could any one point me toward the relevant documentation on this topic?
Else any suggestion about likely SQL syntax or logic error pointer would be very appreciated.

The SQL command above should return the Musician name according to the
search criteria matching the id_musicians value from both tables,
but based on the corresponding Year field/colum value matching the 1978 value.

RUST NEVER SLEEP should be returned for that example.
ibb.co/XLfCvFH

The idea would be next to expand this query to match any "tag" / string value from a given column/field
to replicate the original project.
And ultimately try to do the same with a second treeview instead of a memo3 field to get the final result
of selectable record from the created groups, if possible.

Many thanks again for your next suggestions!

Regards,
Frank

It took me a while (a few years) to acquire these CDs.
But I'll probably put less into capturing them in the project.
Between 15 and 20 a day will eventually do it.
J.B.