|
How to Link to and Update Multiple Files |
|
A program updates the file that is has created. At the same time, it uses list boxes to link to and update ten other files created by other programs. The sample Contacts Database is linked to two files: to Suburbs file and (its own) Contacts Database file. Linking to Other Files: Suburbs file Vancouver is selected from another file, Suburbs.
Clicking the downward arrow of the suburbs list box shows the suburbs:
Here is the other program that updates the Suburbs file:
The screen includes notes (you can remove them if not needed) on how to link Suburbs file to a list box of Contract Database program. Linking to Own File Programs always retrieve records in ascending record keys. In this case, by contact numbers. By linking a program to its own file, you can have different views of the records. For example, you can list records in ascending contact names or by suburbs. The own-list is sorted by ascending contact name. At the same time, the contact number is included to help confirm the record. When a list item is selected, the corresponding record is retrieved.
Updating Other Files A list box contains the keys to another file. Aside from the keys, two more data items may be included. Showing names in addition to codes helps to verify records. |