Relations

CDBF allows you to set relations between tables which have key fields.

So, you can see linked tables together. When you move a cursor in the master table, CDBF automatically selects corresponding records in child tables.

You can set relations in the dialog 'Menu tools - Relations'.
Select a master table, a master field and a child field. After this press OK.

Obviously that a master table can have several child tables. Just repeat the previous step for another child table.

But, what is important, a child table also can have several parents!
How does it work? Call this dialog for the same child table and choose another master table (but the same master and child fields). Then when you move a cursor in the first master table then CDBF selects records according information in this table. When you switch a focus to another master table then CDBF selects records according information in this table.