I dropped an Excel file into filemaker pro 5. It created two fields. The file containes 452 records.

How can I display in layout and browse mode certain records?

For instance I would like to use the first 12 records in a particular calculation. How do I show those 12 on a layout and subsequently use them for calculations?

OR

Should I create 542 fields to read in the records. They are all unique and used in quotes for pricing.

Thanks,

Jim

Create a field called Record Number. Create a script:

Loop

Set Field["Record Number","Status(Current Record Number")

Go to Record/Request[Exit after last,Next]

End Loop

Now put this field (Record Number) on your layout and do a find for <=12 this will show the first 12 records.

Ryan

[email protected]