Drop down list with only subset of values from other file 
Author Message
 Drop down list with only subset of values from other file

I have a file which contains records on films. I have another file which
contains film prints. This file contains a field which is the film id,
in order to provide the relationship with films. I can create a value
list which the film id and film name, sorting on film name. This
provides a list of every film, which is not what I want. Only certain
films in the films file can be have a film print. There is a field in
the films file that identifies this.

I thought I could create a calculated field like:
if (film type = "abc", film id, "")

and use this as the film id but this doesn't work. It just makes the id
blank in the list. Does anyone have any ideas?

--
Matthew Smith
(to reply via email remove xxx)



Sun, 15 May 2005 05:05:30 GMT
 Drop down list with only subset of values from other file

With FMP 5 or later, you can build a conditional value list. In your
scenario, the 'condition' is the 'field in the films file that identifies
this'. If, say, that field is a number field ('Print?'), displaying a
Boolean format ('Yes' or 'No'), but actually storing a 1 or zero, you can
build a relationship ('Printed') from the Print file to the Film file,
using, on the left side (in Prints), a constant field (a calc, returning a
number, defined as 1), and Print? on the right. Your value list will use the
related values, otherwise the same as what you have already built. If the
field is something else, build your matching field in Prints accordingly.

--
John Weinshel
Datagrace
Vashon Island, WA
(206) 463-1634
Associate Member, Filemaker Solutions Alliance


Quote:
> I have a file which contains records on films. I have another file which
> contains film prints. This file contains a field which is the film id,
> in order to provide the relationship with films. I can create a value
> list which the film id and film name, sorting on film name. This
> provides a list of every film, which is not what I want. Only certain
> films in the films file can be have a film print. There is a field in
> the films file that identifies this.

> I thought I could create a calculated field like:
> if (film type = "abc", film id, "")

> and use this as the film id but this doesn't work. It just makes the id
> blank in the list. Does anyone have any ideas?

> --
> Matthew Smith
> (to reply via email remove xxx)



Sun, 15 May 2005 05:55:55 GMT
 Drop down list with only subset of values from other file
That worked.

Actually, I noticed why it worked elsewhere. I had the second field a
calculation based on the same if condition. Since the both fields would
be blank, it won't list the record. In the case of the films I had not
made the second calculation field.



Quote:
> With FMP 5 or later, you can build a conditional value list. In your
> scenario, the 'condition' is the 'field in the films file that identifies
> this'. If, say, that field is a number field ('Print?'), displaying a
> Boolean format ('Yes' or 'No'), but actually storing a 1 or zero, you can
> build a relationship ('Printed') from the Print file to the Film file,
> using, on the left side (in Prints), a constant field (a calc, returning a
> number, defined as 1), and Print? on the right. Your value list will use the
> related values, otherwise the same as what you have already built. If the
> field is something else, build your matching field in Prints accordingly.

> --
> John Weinshel
> Datagrace
> Vashon Island, WA
> (206) 463-1634
> Associate Member, Filemaker Solutions Alliance



> > I have a file which contains records on films. I have another file which
> > contains film prints. This file contains a field which is the film id,
> > in order to provide the relationship with films. I can create a value
> > list which the film id and film name, sorting on film name. This
> > provides a list of every film, which is not what I want. Only certain
> > films in the films file can be have a film print. There is a field in
> > the films file that identifies this.

> > I thought I could create a calculated field like:
> > if (film type = "abc", film id, "")

> > and use this as the film id but this doesn't work. It just makes the id
> > blank in the list. Does anyone have any ideas?

> > --
> > Matthew Smith
> > (to reply via email remove xxx)

--
Matthew Smith
(to reply via email remove xxx)


Sun, 15 May 2005 09:45:21 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Counting non-numeric values in drop down lists

2. Filling drop down edit lists with values

3. Drop Down List Box - Data Value vs Dis

4. drop-down list, default to value?

5. Approach help with attaching values to items in drop down list boxes

6. display drop down list for invalid value

7. List of servers in VB for a drop down list

8. Adding a Heading for Combo/List box Drop Down list

9. Drop down to show another drop down based on selection in first

10. drop down 2 based on drop down 1

11. Cascading Value List Subset(s) ???

12. Subset Value Lists, updating


 
Powered by phpBB® Forum Software