Two layouts, two lists... help!

[garrettks]

I am creating a database with two different types of e-mail discussion lists. Both lists contain all the same fields. But I need to seperate the two lists into diff layouts based on a field in my database called Field Type where I name one list type A and the other type B: I want all of field type A to come up in Layout 1, and all of field type B to come up in Layout two. Can anyone help with this, thanks in advance for your help.

[Kurt Knippel]

quote:

---

Originally posted by garrettks:

I am creating a database with two different types of e-mail discussion lists. Both lists contain all the same fields. But I need to seperate the two lists into diff layouts based on a field in my database called Field Type where I name one list type A and the other type B: I want all of field type A to come up in Layout 1, and all of field type B to come up in Layout two. Can anyone help with this, thanks in advance for your help.

---

What are you trying to accomplish? There are a million way to do what you are asking, but how do we know what your goal is?

Here is an example:

Enter Find Mode []

Set Field [Type, "A"]

Perform Find []

Go To Layout [Format A]

But I do not know if this is what you want to happen.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[garrettks]

Here is an example. I am making a database of all email discussion lists I have. I have two types, one is Lyris, the other is Listserv. I have a "type" field in the database where you can select either Lyris or Listserv. I want all of the Lyris to come up in one Layout and all the Listservs to come up in the second. I'll try what you suggested. I'm still trying to figure everything out. Thanks!

[garrettks]

Ok, that seems to work in the first layout but not the second. Do I need to set up a seperate script or can I put two scripts in one. What I have is two e-mail discussion lists. One is a Lyris type list, the other is a Listserv list. They both contain the same fileds and type of info. I have a type selection in the database, where you pick either Lyris or Listserv. I want all the Lyris to come up in the first layout and all the Listserv to come up in the second layout. Thank you again.

[Kurt Knippel]

quote:

---

Originally posted by garrettks:

Ok, that seems to work in the first layout but not the second. Do I need to set up a seperate script or can I put two scripts in one. What I have is two e-mail discussion lists. One is a Lyris type list, the other is a Listserv list. They both contain the same fileds and type of info. I have a type selection in the database, where you pick either Lyris or Listserv. I want all the Lyris to come up in the first layout and all the Listserv to come up in the second layout. Thank you again.

---

I guess what I was asking is not what you think that you need to do in Filemaker, but what are you trying to accomplish in general. Do you want to goto a layout and have it automatically display the appropriate records, or do you you want to press a button and it selects the appropriate records and displays that on a specific layout or what?

Assuming that you want to press a button and goto a layout (same layout) with the appropriate records displayed:

Go To Layout [List Display]

Enter Find Mode []

Set Field [Type, "Lyris"]

Perform Find []

Do a seperate script for each kind of find criteria.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

[DanHowe]

I think he is trying to have two different layouts....perhaps with different fields, etc.

I suggest you use buttons to go to each layout and those buttons call scripts that perform finds of each specific type before going to that layout.

If you want to change to Layout #2, *boop* press the button find a different set of records and Goto Layout #2.

Is that what you want to do ?

[BruceJ]

I beleive I have a vauge idea about what you're trying to do.

I understand that you have a single flat file and you want two separate lists based.

You can do this two differnet ways, one is to add another field (listSpecify.p) this will be the field you enter the desired list type in. Then create a self joining relationship and match the new field (listSpecify.p) as the parent field with the exisiting field that contains the field type.

Then, create a portal based on this relationship. Add a pop-up menu in the listSpecify.p field, and whalla.. You just choose the type of list from the popup menu and the list appears... magic ehh?

The other way...

Is to create two separate scripts and two buttons, before you crate the scripts you'll need to go into find mode and enter the find criteria for one list at a time, then create a script that peforms the find/restore and then goTo the list view layout.

I like the first one the best, but you ar limited to how the portal is osrted, you can only easily specify the sort order when creating the realtionship. It's rather difficult to create buttons that will sort the protal based on criteria other than was pre-specified when you created the relationship.