Limit records available to certain layout?
I need to have a particular layout only "see" inventory items that are "in stock" (a bolean text field) . I use this layout with Custom Web Publishing and am accessing the FM database through php on my site. I only want the in stock products to show up on the website.
A script make sense, but then every time someone hits "find all" they see all the records, right? Unless I make sure every script has if in stock at the head of it?
thanks for any help in making this easy.