Co-existence of List View and Form View in One Layout 
Author Message
 Co-existence of List View and Form View in One Layout
Can list view and form view co-exist in one layout? For example, a
business contacts database, on the left side of the layout, there is a
list view of people names and on the right side a form view of the
people contact information.

Is this possible?

Eric



Sun, 12 Dec 2004 21:39:20 GMT
 Co-existence of List View and Form View in One Layout

Use a portal for the "list view".


Quote:
> Can list view and form view co-exist in one layout? For example, a
> business contacts database, on the left side of the layout, there is a
> list view of people names and on the right side a form view of the
> people contact information.

> Is this possible?

> Eric



Mon, 13 Dec 2004 01:02:34 GMT
 Co-existence of List View and Form View in One Layout

Quote:
> Can list view and form view co-exist in one layout? For example, a
> business contacts database, on the left side of the layout, there is a
> list view of people names and on the right side a form view of the
> people contact information.

> Is this possible?

> Eric

Yes. Do a self-join relationship and then set up a portal which shows your
"list view." You can even toss a button in the portal with a "Go to related
record" function, which will jump your form view to the proper record.

Hound



Sat, 18 Dec 2004 01:34:46 GMT
 Co-existence of List View and Form View in One Layout
I found that a portal can hold up to 1000 records. How can I do it if
I have more than 3000 records?


Quote:



>> Can list view and form view co-exist in one layout? For example, a
>> business contacts database, on the left side of the layout, there is a
>> list view of people names and on the right side a form view of the
>> people contact information.

>> Is this possible?

>> Eric

>Yes. Do a self-join relationship and then set up a portal which shows your
>"list view." You can even toss a button in the portal with a "Go to related
>record" function, which will jump your form view to the proper record.

>Hound



Sat, 18 Dec 2004 15:02:07 GMT
 Co-existence of List View and Form View in One Layout
Really?  I'm looking at a portal with over 3000 records in it right now (FMP
4.0v3).  The only problem I see is the "slider" in the scroll bar is acting
a little weird.  If I drag it down through about 1700 records it is OK, but
beyond that it just pops back to the top.  But besides that, I can scroll
down through all 3000+ records by clicking in the scroll bar below the
slider (or using the arrows).

Back to your problem...a list of 3000 names is too big to work with in the
first place.  Maybe you can find a way to filter the list down to something
manageable.


Quote:
> I found that a portal can hold up to 1000 records. How can I do it if
> I have more than 3000 records?





<7ngjhu0lkgvjrvjbp1u5aovm43c7hpi137
Quote:

> >> Can list view and form view co-exist in one layout? For example, a
> >> business contacts database, on the left side of the layout, there is a
> >> list view of people names and on the right side a form view of the
> >> people contact information.

> >> Is this possible?

> >> Eric

> >Yes. Do a self-join relationship and then set up a portal which shows
your
> >"list view." You can even toss a button in the portal with a "Go to
related
> >record" function, which will jump your form view to the proper record.

> >Hound



Sat, 18 Dec 2004 22:10:33 GMT
 Co-existence of List View and Form View in One Layout

Quote:
> Back to your problem...a list of 3000 names is too big to work with in the
> first place.  Maybe you can find a way to filter the list down to something
> manageable.

Or, look at "Portal filter" plugin by Waves in Motion, if 49 USD are reasonable
for You. Otherwise it's better to avoid portals!

/Steve

Quote:

> <7ngjhu0lkgvjrvjbp1u5aovm43c7hpi137


>>>>Can list view and form view co-exist in one layout? For example, a
>>>>business contacts database, on the left side of the layout, there is a
>>>>list view of people names and on the right side a form view of the
>>>>people contact information.

>>>>Is this possible?

>>>>Eric

>>>Yes. Do a self-join relationship and then set up a portal which shows

> your

>>>"list view." You can even toss a button in the portal with a "Go to

> related

>>>record" function, which will jump your form view to the proper record.

>>>Hound



Sat, 18 Dec 2004 22:35:18 GMT
 Co-existence of List View and Form View in One Layout
There are indeed some limits to portal size.  You can't make a portal larger than
1,000 rows, although with a scrollbar you can scroll down more rows.

Also, the information you can see and scroll to within the portal is limited to
32,767 pixels in height.  For instance, if the portal shows 10 rows and each row
is 10 pixels high, the portal would be able to show 3,276 records.

Further, the maximum length of a layout is approximately 8000 pixels (or 111
inches)-- so unless you are making each portal row less then 8 pixels high, which
is starting to get to be unreadable, why bother going beyond the 1000 row limit.

And as anyone who cares about their users' sanity would tell you, why on earth
would you want to make your users scroll through either 1000 portal records or
through 111 inches of screen real estate?!?!?  You should find a way of
categorizing the names into smaller lists -- maybe by letter of the alphabet,
maybe by job or customer category, or maybe you have the user type the first 1-5
letters and the portal list reflects the results of their entry.

Quote:

> I found that a portal can hold up to 1000 records. How can I do it if
> I have more than 3000 records?





> >> Can list view and form view co-exist in one layout? For example, a
> >> business contacts database, on the left side of the layout, there is a
> >> list view of people names and on the right side a form view of the
> >> people contact information.

> >> Is this possible?

> >> Eric

> >Yes. Do a self-join relationship and then set up a portal which shows your
> >"list view." You can even toss a button in the portal with a "Go to related
> >record" function, which will jump your form view to the proper record.

> >Hound

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg              (818) 321-5176
FM Pro Solutions       Los Angeles, California
Associate Member, FileMaker Solutions Alliance


Sat, 18 Dec 2004 23:10:40 GMT
 Co-existence of List View and Form View in One Layout
You could do this vertically. Use a list view in the related file and place
the contact (related in the other direction) data in the a header. Clicking
on a record will cause the header to reflect the current record's contact
data. So, no more crappy portal scrollbars. Okay, you can't edit the contact
data directly but a simple GtRR solves that.

Chris



Sun, 19 Dec 2004 03:21:13 GMT
 
 [ 8 post ] 

 Relevant Pages 

1. odd things happening between layout view and table view

2. Viewing 2 layouts at once and imporing layouts

3. Is it possible to combinbe remote views into one view

4. Form View from rows of table to columns of view

5. Form View/Table View

6. Isolating one record for list view

7. One to Many Forms w/ Views.

8. One to Many forms /w Parameterized Views

9. How are views on views on views executed ??

10. How to emulate a list of results, without list-view

11. viewing range of records one by one


 
Powered by phpBB® Forum Software