elisacarli <elisacarli@[EMAIL PROTECTED]
> wrote:
> On 17 Apr, 17:49, Howard Schlossberg
> <how...@[EMAIL PROTECTED]
> wrote:
> > 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.
> That you described is just what I'm trying to do.
> Could you give me more detailed informations on how to perfom a find
> from a layout based on the Order table?
make a relation****p as Howard says
make a re****t (listing style) of table Employee with fields Name,
Surname, item, ****pment, and the field country as not printable menu,
or select boxes, or other presentation as you like.
in the search mode, write USA in the contry field, and then return.
You can print the listing.
HTH
|
