The short version: Is it possible to restrict the records in a Found
Set based on Layout Name without scripting?

I'm using FMA 8.0v2 on Mac OSX to develop for 7.0-8.5.

The long version:

I've got a legacy database that I'm upgrading. The client has been
using 6 tables to accomplish what I think could be done with two. They
have two tables each for Sales, Transfers, and POs: SalesOrders,
TransferOrders, and PurchaseOrders and SalesLineItems,
TransferLineItems, and PurchaseLineItems.

I want to consolidate them all into two tables: Orders with a field
TypeOrder and Transactions with a field TypeTransaction. I will keep
the three different Order layouts as they capture different
information.

The clients are used to working directly with the New and Find
commands.

When making a new Sales Order, I can ensure TypeOrder is set with an
Auto-Enter calc = Case(Get(LayoutName) = "SalesOrder"; "Sale";
Get(LayoutName) = "PurchaseOrder", and so on.

But I can't (and don't know if it's possible) to allow users to Apple-F
while in one of the Orders layouts and get results that include just
those TypeOrder.

I could use Custom Menus to restrict that I suppose, but I'm a leery of
CMs as I've had one irrecoverable crash after working on them in
another file. Also, are Custom Menus functional in 7.0?

Thanks,
G

Short answer: No.

Finds are tied to the Table. Except for the obvious (which fields are
available to search), the layout plays no part in the Find.

Matt

In article <1161979334.120593.182480 (AT) f16g2000cwb (DOT) googlegroups.com>,
"Grip" <grip (AT) cybermesa (DOT) com> wrote: