Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Calculation HELP!!!

0 views
Skip to first unread message

vaggelis

unread,
Nov 3, 2009, 2:23:00 PM11/3/09
to
hello,

in my database products and services are in the same table( items )
i want to create a portal in which there will be the option to show
only the names of the item-services and not the names of the item-
products!


can somebody help me?
thanks

Christoph Kaufmann

unread,
Nov 3, 2009, 3:18:21 PM11/3/09
to
vaggelis <pant...@gmail.com> wrote:

> in my database products and services are in the same table( items )

Make a text field called "type" that states whether the item is a
product or a service. Then you can search for services and you the
result set is what you are looking for:

> i want to create a portal in which there will be the option to show
> only the names of the item-services and not the names of the item-
> products!

Don't know what you need a portal for, but here's how: create a text
field with global storage and attach a value list to it that draws its
values from the field "type"

Then create a relation from this global text field to the field "type".
Base the portal on that relation. It will show services or products,
depending what you put it in the global field. Look for "filter portals"
if you need more help.
--
http://clk.ch

0 new messages