Re: Showing a Set in a Layout



In article
<8028c4ca-f4aa-45c4-9dc4-31fd956e3126@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
Buckbuck <buck.matthew74@xxxxxxxxx> wrote:

FM 8.5

I have a CONTACTS table. One of the Fields is Notes. I want to create
a Layout that will show only those Contacts that meet a certain
criteria, Retailers for example. Is this possible or do I have to
enter the Layout through a Script to effect a Find function.

Thanks
Matthew

You have to perform, or script, a Find.

Alternatively, you could create a relationship that would be satisfied
for records that meet the criteria, and then show those records in a
portal. One way to do this is to create a new table "Criteria", with a
text field that contains the criteria. Then show the related records in
a portal of a layout based on the Criteria table.

--
Bill Collins
For email, change "fake" to "earthlink"
.



Relevant Pages

  • Re: use find on button fields
    ... The workaround is either to tab into the field or script entry using Go To ... Running a script in Layout Mode switches FileMaker back to Browse Mode ... In a scripted Find process, go to that layout to enter your Find criteria, and include a step to return to the original layout once the Find is complete. ... the user will always forget the modifier keys, and run the script on button click anyway. ...
    (comp.databases.filemaker)
  • Re: Count distinct based on criteria
    ... criteria values are in B1:B4. ... in rows and values in columns - sales reps. ... I'm no sure what you mean by columns layout? ... A pivot table is almost what I need, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: [9fans] Mousing is faster than typing but users do not believe it
    ... Layout version 9.2/10 (I didn't bothered to use a newer version because the ... Yes, they were very organized based on some criteria, but my ... the one of the best UIs I ever used was Viewlogic for DOS. ... It used a command window and mouse combination. ...
    (comp.os.plan9)
  • Re: organization
    ... If such a layout change were to happen I think the least time wasting ... - issue a request for new layout propositions ... No consensus, no change. ... > weird criteria to use? ...
    (freebsd-hackers)
  • Re: Layout Preview drops criteria
    ... The Layout Preview is just a layout preview and ... If it did apply criteria, ... pull only personnel at a certain location, but in Layout Preview, ALL ... > Is there any way to include the actual data instead of sample data? ...
    (microsoft.public.access.reports)