Hi

My database consists of two tables, containing the following fields:

Table A Table B
(relation)
Invoiceno. <---> Invoiceno.
Articleno. Invoiceadr.
Count Date

To read out all fields in one layout, I have created a portal containing
Articleno. and Count.

Everything works fine.

SEARCH:

However I cannot search the portal fields - except the first linie. Does
anybody know how this can be done or an alternative way?

COMPARE:

If I want to compare the fields (e.g. Articleno.) enclosed in the portal by
comparing with some fields with "Maximum number of repetitions"=20, how can
this be done or is there an alternative way?

Thank you very much for any help you can provide!

Daniel

I forgot to mention that I would like to perform a AND search, because I
only want to records to be shown, which match all of the criteria.

/Daniel

You're not finding just the first line of the portal.

A find in a portal returns all records in which portal records match the
criteria, regardless which line contains the match.

You do an AND find in a portal the same as any other: more than one
criteria in a request is an AND find.

Matt

D wrote:

However, I just found out that if you do a Find for content in two
different fields in the same portal (which should be an AND find
operation), FM will return records that fit EITHER criteria (an OR
find).

I had to create a calculated field in the child file to combine the
content of the two fields, then do the Find on that.

Paul Bruneau wrote:

I see the point, but I think it is still an AND find of sorts; the portal
contents are apparently being treated as a whole, rather than as
individual records.

I searched on two criteria in my portal: today's date and a text notation
common in my data, and got 9 returns. Finding just today's date returned
17, just the text note returned 157.

Performing the find directly in the portal's source table returned
entirely different results.

In my test, it is finding those parent records where the portal contains
both today's date and the text notation, even if those criteria don't both
exist in the same portal row.

But, you're right: combining the two fields eliminates that behavior.

Matt
[FMD7, WXP]

Can a portal's contents be exported to individual fields?

And how is that done?

/Daniel

In article <42caf21e$0$162$edfadb0f (AT) dread11 (DOT) news.tele.dk>,
"Daniel" <danieldk121fjerndette (AT) hotmail (DOT) com> wrote:

A portal's contents already are individual fields, in related tables as
specified in the definition of the Portal.

What are you trying to do, that prompts your question?

Bill Collins

--
For email, remove invalid.

Hi Bill

I am trying to create a "AND search", which will combine the individual
search criteria in one search.

/Daniel

In article <42cb6846$0$189$edfadb0f (AT) dread11 (DOT) news.tele.dk>,
"Daniel" <danieldk121fjerndette (AT) hotmail (DOT) com> wrote:

You can write a scripted FIND, that uses fields in related tables as
part of the search criteria. A scripted find can be set up to include
Boolean AND and OR and NOT criteria. Such a scripted FIND does not
depend on a portal, but on the field values in the specified tables. The
tables specified can be the "home" table, that is the context for the
script, or any related table.

Bill

--
For email, remove invalid.