B-Man Posted June 22, 2001 Share Posted June 22, 2001 I have a layout that I need to be able to display all of the records from another file. The second file has 100 records and will always onlly have a 100 records. I need to be able to have them in a column format (in browse mode) where column1 displays records 1-20, column2 21-40, ect.... . Is this possible? Thanks, Brian Link to comment Share on other sites More sharing options...
Kurt Knippel Posted June 23, 2001 Share Posted June 23, 2001 quote: Originally posted by brian cryderman: I have a layout that I need to be able to display all of the records from another file. The second file has 100 records and will always onlly have a 100 records. I need to be able to have them in a column format (in browse mode) where column1 displays records 1-20, column2 21-40, ect.... . Is this possible? Easy as pie. You will need 5 portals, 5 relationships and 5 multi-key fields in your display database. First create a simple serial number in your "Second" file. Set this with number 1-100. In your "First" file setup 5 fields that have the following ranges of numbers in them 1-20, 21-40, 41-60, 61-80 and 81-100. Each number should be on a seperate line: 1 2 3 4 etc. Now setup a relationship from each of those fields to the serial number field in the "Second" file. Then setup 5 portals each showing one of those relationships, with 20 lines. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8343 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