Master-Detailed

Hi Smoustafa, Mathmathou, Dmitry,

Normally, you would  use a separate form to show the fields of the record you select in the tablegrid.  But there is nothing to stop you from showing those fields on the same form.

Attached is Mathmathou's example but done without using a script.  (Sorry Mathmathou - I was too lazy to write an example so I stole yours - LOL!).

Hope this helps.

Derek.

Hello Mathmatou, sMustapha and Derek

I same the same project for an application about wild flowers in France.
I use another solution to display informations but result is the same.
But a new flower is entered on another form.
On the same form, I placed a grid listing all items of table flowers and beside a panell
with all fields of the table (including photos of flower and leaf)

Here a piece of my code to display infos I do that because I have many tables joined) :

procedure Accueil_TableGrid1_OnCellClick (Sender: string; ACol, ARow: Integer);
Var  s : String;
begin           
       Accueil.DBImage1.LoadFromDatabase('fleurs', 'photo', Accueil.TableGrid1.dbItemID);
       s := SQLExecute('SELECT Familles.Famille from Fleurs left outer join Familles on Fleurs.id_Familles = Familles.id where Fleurs.id = '+         IntToStr(Accueil.TableGrid1.dbItemID));
     Accueil.Label5.Caption := 'Famille : ' + s;

     s := SQLExecute('SELECT Couleurs.Couleur from Fleurs left outer join Couleurs on Fleurs.id_Couleurs = Couleurs.id where Fleurs.id = '+ IntToStr(Accueil.TableGrid1.dbItemID));
     Accueil.Label6.Caption := 'Couleur : ' + s;.....

and so on (there 28 fields)

And I do same thing behind 

procedure Accueil_TableGrid1_OnKeyDown (Sender: string; var Key: Word; Shift, Alt, Ctrl: boolean);
procedure Accueil_TableGrid1_OnKeyUp (Sender: string; var Key: Word; Shift, Alt, Ctrl: boolean);

with a DoubleBuffered to avoid flicker in the image change.

With Delphi, all is possible

JB

Hello all

@Derek and Dmitry

Guys... guys... would you believe me if I told you I was not even aware this was possible without scripting ? Derek's solution with double-clic and Dmitry's with simple clic...

Love you guys... this will spare me a lot of coding

We should always choose the simpler solution, shouldn't we

Thanks for the tips !!

@smoustafa

now you have plenty of examples

@jean

Curious about your dubblebuffer thing

Cheers

Mathias

Thank you Derek for the project.

I'll dissect it as thoroughly as possible to avoid "over-coding" on my future project

Cheers

Mathias