I am trying to write a staff sign in/off history system and this is the first problem I encounter For example (Table1) ID (Primary Key) Staff Name (Table2) ID (Primary Key) Sign in time (Primary Key) Sign off time The two tables is created and reltated using Microsoft Access together (Table1) One to Many (Table2) method. Now (in Access) each ID in table1 will have a subsection containing all the information belong to that ID in Table 2. Is that possible to achive such function in Delphi: The ideal design is: When a record is selected in Table1, the sub-section of the select will be shown in another dbgrid, listing, etc. Thanks

It is a fundamental question. You can search topics and use key word ‘master-detail’ on this site.     資料庫種類繁多, 記得先說用啥資料庫喔