Thank you for your post.
I am having difficulty understanding your question.
Pull down File menu and select "Manage -> Database...". Click the "Relationships" tab. You will now see graphical representations of your tables. To create a relationship between two tables, find the common field between the two tables, click on one of those fields and drag it to the field in the second table. When you let go, your tables will now be connected to one another. Half way between the two tables is now an icon. Double-click on the icon to edit the relationship. One table appears on the left side, and the other table appears on the right side. Since you want to add new appointments to your agenda table, make sure that you select "Allow creation of records in this table via this relationship" for the side that displays the Agenda table. Then, when you are in the other table, you can add appointments to the agenda table.
In your layout, add a portal (using the Portal tool) and connect to the agenda table. You can then add records.
Thank you for the explenation but that was not my problem.
I have 3 tables:
In table3 i want to see the records of table1 AND table2. I can make the relations to see the records of only one table, but not to see the records of the 2 tables (table1 and table2).
Do you understand what i mean?
There's no such thing as a 'union' in FileMaker, so the closest you'll come to seeing multiple tables on one layout are portals, based on related tables. Or, examine your db structure, and combine the Orders and Events tables into one table.
Thank you for the clarification.
The answer from "etripoli" is correct (Thank you!). That is, you cannot easily show both ORDERS and EVENTS in the same portal. However, you can set up two portals. One into ORDERS and one into EVENTS. Therefore, make the first relationship from AGENDA into ORDERS and the second relationship from AGENDA into EVENTS.
Does that make sense?