i have a database with both software and non-software assets in it. i was told to keep it in the same table within the same database but with two different layouts. as it is now, there are the two layouts which i have a button to switch between when i get to something that looks like software to see it in the right form.

i was wondering...is there a way to set up a filter or something so that if someone was going through all the assets...if it got to a software asset, it would display it in the software form, and if it got to a non-software asset, it would display it in that form?

i am new to filemaker...i have done a little scripting in it so far, but i can't really see where to go with this.

thanks.

If you script the navigation, i.e. make your own "forward" and "back" buttons, the script is pretty straightforward. You can use a single script with a separate script parameter for each button:

// First go to the next or previous record

If [ Get ( ScriptParameter ) = "forward" ]

. Go to record [next]

Else

. Go to record [previous]

End If

// Now look at the category field and change layout

If [ asset = "software" ]

. Go to layout [ software ]

Else

. Go to layout [ non-software ]

End If

Thank you so much it worked.