Hi all,
I made a valuelist based on related values.
In the M-+ Combobox M-; the values are shown, but duplicates are shown as well !
(several records have the same value and are shown serveral times in the value list)
How can I avoid this ?
Br
Stef
Values in related value lists
9 posts
• Page 1 of 1
Values in related value lists
by Stef » Mon Jun 23, 2003 1:07 pm
- Attachments
-
- vl.jpg (6.47 KiB) Viewed 7842 times
- Stef
- Posts: 208
- Joined: Wed May 28, 2003 2:19 pm
- Location: Kasterlee, Belgium
by jcompagner » Mon Jun 23, 2003 2:53 pm
What is the value that you set in the end?
is that also the string you see? Or the id behind it?
Because if it is the ID then which string must be filterd out of the 2 values that are equal?
If it is the string. Why are there 2 string with the same value then in the first place?
Maybe we can filter dups out when the returned value is the same as displayed value. But i think this must be somekind of option.
is that also the string you see? Or the id behind it?
Because if it is the ID then which string must be filterd out of the 2 values that are equal?
If it is the string. Why are there 2 string with the same value then in the first place?
Maybe we can filter dups out when the returned value is the same as displayed value. But i think this must be somekind of option.
-
jcompagner - Posts: 8833
- Joined: Tue May 27, 2003 7:26 pm
- Location: The Internet
by jcompagner » Tue Jun 24, 2003 8:28 pm
Not a bug but not implemented (it is not that easy)
With all from table we can do a select distinct() when the return and display value is the same.
this is a bit harder to do when you select related.
We have it on our list to look at.
With all from table we can do a select distinct() when the return and display value is the same.
this is a bit harder to do when you select related.
We have it on our list to look at.
-
jcompagner - Posts: 8833
- Joined: Tue May 27, 2003 7:26 pm
- Location: The Internet
by maarten » Wed Jul 16, 2003 11:38 am
I want the valuelist to be editable by the user, like in FMP.
We intentionally didn't add the "edit" option in pulldown lists, because we think valuelists shouldn't be accessable to all users.
The easiest way to set up a maintainable valuelist mechanism is:
1) create a table named "valuelists"
2) create a column for each valuelist you need. eg: column "category"
3) in the valuelist editor create a valuelist named "categories".
settings:
- All values from table "valuelists"
- show/return column "category"
etc...
Maarten Berkenbosch
-
maarten - Posts: 797
- Joined: Wed Apr 23, 2003 10:52 pm
- Location: Amersfoort, Netherlands
9 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 20 guests