elisacarli wrote:
> Table Employee - Name, Surname, IdOrder
> Table Order - idOrder, Item, ****pment, Country
>
> SQL Statement
> SELECT Name, Surname, Item, ****pment
> FROM Employee INNER JOIN [Order] ON Employee.[IDOrder] = Order.
> [IDOrder] WHERE Country="USA";
>
> I need a Filemaker Format (re****t) in which I can see field Name,
> Surname, Item, ****pment WHERE Country =USA.
It's not clear to me why you would have and Order ID in the Employee
table, so I'm going to assume that what you meant is that you'd have an
Employee ID each table as your match field. That being the case...
Create a relation****p from Order::IDEmployee to Employee::IDEmployee.
Perform a find from a layout based on the Order table, searching just
the Order::Country field for USA.
FileMaker has relation****ps instead of joins. Once you have established
a relation****p, you can search on any field in either of the two tables.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles
FileMaker 8 Certified Developer
Member, FileMaker Business Alliance
|
