| Computers Forum Index » Computer - Databases - Filemaker » Calculation HELP!!!... |
|
Page 1 of 1 |
|
| Author |
Message |
| vaggelis... |
 Posted: Tue Nov 03, 2009 7:23 pm |
|
|
|
Guest
|
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 |
|
|
| Back to top |
|
|
|
| Christoph Kaufmann... |
| Posted: Wed Nov 04, 2009 1:18 am |
|
|
|
Guest
|
vaggelis <pantidos at (no spam) gmail.com> wrote:
Quote: 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:
Quote: 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 |
|
|
| Back to top |
|
|
|
|
