VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

VISUAL QUICKPRO GUIDE FileMaker Pro 7 Advanced FOR WINDOWS AND MACINTOSH [Electronic resources] - نسخه متنی

Cynthia L. Baron, Daniel Peck

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید











Creating a Match Field in the Current Table


To use data from the source table you've created a match field in, you also need a match field in the current (destination) table. Once you have both match fields, you define a relationship that links the receiver to the source.

To create a match field in a current table



1 .In the destination file, go to File > Define > Database (Control+Shift+D/Command+Shift+D). Click the Fields tab.

2 .Define a new number field and name it. This example is named Key Serial to match the source field of the same name. Click Create, then OK.

3 .If the table you are creating the relationship to is not contained in the same database, follow the steps in "To create a file reference" in the preceding section.

4 .

Choose File > Define > Database (Control+Shift+D/Command+Shift+D). When the Define Database dialog box appears, click the Relationships tab. In the Tables/Relationships section, click the Add Table button (Figure 6.11).

Figure 6.11. To define a new relationship, begin by adding the source table.


[View full size image]

5 .When the Specify Table dialog box appears, select a file reference from the File drop-down menu (Figure 6.12), then choose the table to be related. Click OK.

Figure 6.12. To relate a table to the current one, choose the source table from the drop-down list.


6 .In the Tables/Relationships section of the Relationships tab, click the Create Relationship button (Figure 6.13).

Figure 6.13. Manage relationships through the Tables/Relationships buttons.


7 .

When the Edit Relationship dialog box appears, choose the current table occurrence in the left table drop-down list. Choose the related table occurrence in the right drop-down list (Figure 6.14).

Figure 6.14. Choose the related table from the drop-down list on the right.


[View full size image]

8 .Click the Key Serial field in the field lists under both tables, then click the Add button (Figure 6.15). Click OK.

Figure 6.15. Choose the key fields in both tables from each field list.


[View full size image]

The new relationship will be shown as a connecting arrow in the Relationships graph (Figure 6.16).

Figure 6.16. The new relationship appears in the Relationships graph as a line connecting the key fields.


[View full size image]



/ 227