jimpres Posted August 5, 2000 Share Posted August 5, 2000 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 Link to comment Share on other sites More sharing options...
ryan93 Posted August 7, 2000 Share Posted August 7, 2000 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] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8672 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now