asked on

How to display only selected products in a view ?

I have created a form and in that form, I have create 2 sections called Licensed Software (comprise of table with licensed names)and another called Unlicensed Software (comprise of a table with unlicensed names).
In a view that I create, I want to display only Licensed Software and for the view selection formula, I have ->
SELECT form="PC Software" & section = "Licensed Software" but it display nothing at all.

What's wrong here?
Pls help.
Thanks.

marilyng

Kopibean,

"Section" is not a selectable item in a view. The fields contained in the section can be isolated:

Select (form="ThisFormName" | form="thisformAlias") AND (LicensedNameField <>"");@All

Or,

Select (form="ThisFormName" | form="thisformAlias");@All

And configure the columns to display the unlicensed Software fields:

Col1: LicensedSoftwareCategory
Col2: LicensedSoftwareName
Col3: OtherFieldName or Formula

Where "UnlicensedNameField" is the name of the required or main field in the Licensed Software Table, or the one that will most likely be filled in by the user when licensed software is entered on the form as opposed to unlicensed software.

Hope this helps,
marilyng

marilyng

Oops, typo -- "configure the columns to display the licensed software fields"

regards,
marilyng

ASKER CERTIFIED SOLUTION

sloeber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

marilyng

I thought of suggesting this, only because it's easier to do the collection, but didn't.. smile..

marilyng

snocross

Listening...