لطفا منتظر باشید ...
Creating Related Data with Portals
One nice thing about portals is that they are more than a way to display data from one table in a different table. They also give you a way to create new records in the destination table based on information from the source table. When you enter a new record with a portal, the key field in the related table has the contents of the match field in the main table entered automatically.
To enter data in related tables using portals
1 .Go to the current table layout where the portal will be added, and switch to Layout mode (Control+L/Command+L).2 .Make sure the layout has enough room for the portal. If it doesn't, drag the Body tab down to resize the part.3 .Click the Portal tool. Click on the layout and drag the pointer out and down to size.4 .Choose File > Define > Database (Control+Shift+D/Command+Shift+D). When the Define Database dialog box appears, click the Relationships tab.5 .Double-click the relationship connector (=) to bring up the Edit Relationship dialog box (Figure 6.31).
Figure 6.31. You can edit an existing relationship by double-clicking its relational operator box on the Relationships graph.
[View full size image]
Figure 6.32. When the first blank row in a portal is clicked, a new record is created in the related database and the new data you enter is added to the record.
[View full size image]
Figure 6.33. You can go to the related table to see the contents of the new record.
[View full size image]
