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.
| Common information |
| Overview |
| Features |
| Quick start |
| Main window |
| Menu |
| File |
| View |
| Edit |
| Commands |
| Tools |
| Plugins |
| Favorites |
| Windows |
| Help |
| Dialogs |
| Append From |
| Auto Fill |
| Calculator |
| Columns |
| Compare |
| Customize toolbar |
| Create |
| Database info |
| Designer |
| Encoding |
| Export |
| Favorites |
| Field info |
| Fill |
| Filter |
| Find |
| Go field |
| Go record |
| Group |
| Group by |
| Header editor |
| Memo Editor |
| Modify Structure |
| Options |
| Replace |
| Relations |
| Sort |
| Statistics |
| Wipe information |
| Additional |
| License |
| How to register |
| Feedback |
| Keyboard |
| Tips and Tricks |