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

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.