Dynamic drop down using calculation field?

Hello,

I use FM 8.

I have 2 tables. One tables stores the data for the courses being
offered. It has the fields name of the course,date open,date closed,
course id (unique id).

The second table is the enrollment form where in the students enter
the information about the courses. This has fields student name and a
drop down with the courses, course id(unique id).

I need to populate this courses drop down from the first table. But,
it should show only the courses whose closing date is after the
current date.

How do I do this? They have a relationship on their course id.

I have tried using a calculation field . But it gets me no where.

Thanks a ton!
Deepti

Re: Dynamic drop down using calculation field?

Deepti

Create an unstored calculation in the courses offered table.
rough outline: if ( ClosingDate > CurrentDate ; CourseName ; "" )
Create a value list based on this field.

Keep Well, Ursus

"Deepti" schreef in bericht
news:6c4c8eb9-6cf5-42a9-9070-fc382d9d4974@i7g2000prf.googleg roups.com...
> Hello,
>
> I use FM 8.
>
> I have 2 tables. One tables stores the data for the courses being
> offered. It has the fields name of the course,date open,date closed,
> course id (unique id).
>
> The second table is the enrollment form where in the students enter
> the information about the courses. This has fields student name and a
> drop down with the courses, course id(unique id).
>
> I need to populate this courses drop down from the first table. But,
> it should show only the courses whose closing date is after the
> current date.
>
> How do I do this? They have a relationship on their course id.
>
> I have tried using a calculation field . But it gets me no where.
>
> Thanks a ton!
> Deepti

Re: Dynamic drop down using calculation field?

Hi Ursus,

Thanks a ton for the help. I am newbie to Filemaker...so just
clarifying what you mean:

I should have a calculation field on the courses table? But how do I
have an unstored field?

am so sorry for asking these silly questions!

Thanks a ton!

On Feb 1, 1:59=A0pm, "Ursus" wrote:
> Deepti
>
> Create an unstored calculation in the courses offered table.
> rough outline: if ( ClosingDate > CurrentDate ; CourseName ; "" )
> Create a value list based on this field.
>
> Keep Well, Ursus
>
> "Deepti" schreef in berichtnews:6c4c8eb9-6cf5-42a9=
-9070-fc382d9d4974@i7g2000prf.googlegroups.com...
>
>
>
> > Hello,
>
> > I use FM 8.
>
> > I have 2 tables. One tables stores the data for the courses being
> > offered. It has the fields name of the course,date open,date closed,
> > course id (unique id).
>
> > The second table is the enrollment form where in the students enter
> > the information about the courses. This has fields student name and a
> > drop down with the courses, course id(unique id).
>
> > I need to populate this courses drop down from the first table. But,
> > it should show only the courses whose closing date is after the
> > current date.
>
> > How do I do this? They have a relationship on their course id.
>
> > I have tried using a calculation field . But it gets me no where.
>
> > Thanks a ton!
> > Deepti- Hide quoted text -
>
> - Show quoted text -

Re: Dynamic drop down using calculation field?

Ursus,

Here is what I did (validateDate is the calculation field) defined
as :

If ( Date closed > Get(CurrentDate) ; ValidateDate =GetField ( Name of
the course ) ; ValidateDate ≠ Name of the course )

This gives me 0 or 1 as a result in the field. How do I get the name
of the course there?

Thanks a ton!


On Feb 1, 5:10 pm, Deepti wrote:
> Hi Ursus,
>
> Thanks a ton for the help. I am newbie to Filemaker...so just
> clarifying what you mean:
>
> I should have a calculation field on the courses table? But how do I
> have an unstored field?
>
> am so sorry for asking these silly questions!
>
> Thanks a ton!
>
> On Feb 1, 1:59 pm, "Ursus" wrote:
>
>
>
> > Deepti
>
> > Create an unstored calculation in the courses offered table.
> > rough outline: if ( ClosingDate > CurrentDate ; CourseName ; "" )
> > Create a value list based on this field.
>
> > Keep Well, Ursus
>
> > "Deepti" schreef in berichtnews:6c4c8eb9-6cf5-42a9-9070-fc382d9d4974@i7g2000prf. googlegroups.com...
>
> > > Hello,
>
> > > I use FM 8.
>
> > > I have 2 tables. One tables stores the data for the courses being
> > > offered. It has the fields name of the course,date open,date closed,
> > > course id (unique id).
>
> > > The second table is the enrollment form where in the students enter
> > > the information about the courses. This has fields student name and a
> > > drop down with the courses, course id(unique id).
>
> > > I need to populate this courses drop down from the first table. But,
> > > it should show only the courses whose closing date is after the
> > > current date.
>
> > > How do I do this? They have a relationship on their course id.
>
> > > I have tried using a calculation field . But it gets me no where.
>
> > > Thanks a ton!
> > > Deepti- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -

Re: Dynamic drop down using calculation field?

Sorry for so many emails but I've figured it out!

Thanks a million Ursus!

Deepti


On Feb 1, 5:53 pm, Deepti wrote:
> Ursus,
>
> Here is what I did (validateDate is the calculation field) defined
> as :
>
> If ( Date closed > Get(CurrentDate) ; ValidateDate =GetField ( Name of
> the course ) ; ValidateDate ≠ Name of the course )
>
> This gives me 0 or 1 as a result in the field. How do I get the name
> of the course there?
>
> Thanks a ton!
>
> On Feb 1, 5:10 pm, Deepti wrote:
>
> > Hi Ursus,
>
> > Thanks a ton for the help. I am newbie to Filemaker...so just
> > clarifying what you mean:
>
> > I should have a calculation field on the courses table? But how do I
> > have an unstored field?
>
> > am so sorry for asking these silly questions!
>
> > Thanks a ton!
>
> > On Feb 1, 1:59 pm, "Ursus" wrote:
>
> > > Deepti
>
> > > Create an unstored calculation in the courses offered table.
> > > rough outline: if ( ClosingDate > CurrentDate ; CourseName ; "" )
> > > Create a value list based on this field.
>
> > > Keep Well, Ursus
>
> > > "Deepti" schreef in berichtnews:6c4c8eb9-6cf5-42a9-9070-fc382d9d4974@i7g2000prf. googlegroups.com...
>
> > > > Hello,
>
> > > > I use FM 8.
>
> > > > I have 2 tables. One tables stores the data for the courses being
> > > > offered. It has the fields name of the course,date open,date closed,
> > > > course id (unique id).
>
> > > > The second table is the enrollment form where in the students enter
> > > > the information about the courses. This has fields student name and a
> > > > drop down with the courses, course id(unique id).
>
> > > > I need to populate this courses drop down from the first table. But,
> > > > it should show only the courses whose closing date is after the
> > > > current date.
>
> > > > How do I do this? They have a relationship on their course id.
>
> > > > I have tried using a calculation field . But it gets me no where.
>
> > > > Thanks a ton!
> > > > Deepti- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -

Re: Dynamic drop down using calculation field?

In article
,
Deepti wrote:

> Ursus,
>
> Here is what I did (validateDate is the calculation field) defined
> as :
>
> If ( Date closed > Get(CurrentDate) ; ValidateDate =GetField ( Name of
> the course ) ; ValidateDate ≠ Name of the course )
>
> This gives me 0 or 1 as a result in the field. How do I get the name
> of the course there?
>
> Thanks a ton!

There's a lot of confusion in that calculation. It should just be:

If (Date Closed > Get(CurrentDate); CourseName; "")

which says:
If the Date Closed is after "today", then store the CourseName,
otherwise leave the calculation field empty (ie. store nothing, "").

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)