Link two tables
lazarus / 16-Databases

----------------------------------------------------------------------
Emmanuel · 2014-09-19 06:43

I have 2 tables (dbf, tables) linked by a commun field. I have
difficulties to create the link between these 2 tables and create a
MasterFields, have you got any example to help me   


Thank you for your help

Emmanuel

----------------------------------------------------------------------
mangakissa · 2014-09-19 06:53

What have you done already.

----------------------------------------------------------------------
Emmanuel · 2014-09-19 07:02

Almost nothing  , I just create a form with 2 tables : I can see the
data in my tables and also used a DBnavigator to move inside my table
but I would like to link these 2 tables, it should be easy, but I m
stack


Thank you for your support

----------------------------------------------------------------------
wdn · 2014-09-19 09:48

Does the relation work between 2 DBgrid objects?
Start making an excercice as explained in
wiki.freepascal.org/masterdetail

Wim

----------------------------------------------------------------------
howardpc · 2014-09-19 16:29

Attached is a simple project that illustrates a very simple master-
detail TDBF setup.
Most of the settings are done explicitly in code rather than using the
Object Inspector, so you can see the important properties and indexes
that need to be set up. Otherwise these settings may be overlooked in
the Object Inspector (or are more hidden in the form's .lfm file).
Best practice is to use a datamodule to contain your data objects and
files, but that is omitted from this example for simplicity.