Hi all

I'd really appreciate it if anyone had a couple of moments just to look at
something which has me completely puzzled.

I've uploaded an example of this, if you have FM12 you can see my issue in
action...
www.camise.co.uk/examples/conditionalDate.fmp12

Here is what we have

A very very basic example

Layout 1 (conditionalDate)

Field: Location
Field: Date

Layout 2 (Reports) this is a TO of the original table

Field: g_Location (global)
Field: g_Conditional Date

Joined by conditionalDate::Location - Reports::g_Location

On reports we have 2 value lists

The first is Location. This value list lists all entries made in the
original table, works as you would expect.

The second value list is set to list all dates loaded against the selected
location. This works.. but only in some cases. On certain dates it just
displays a ?

So in the example I uploaded we have...

Location: Office 2 Date: 18/10/2012
Location: Office 2 Date: 11/12/2012
Location: Office 2 Date: 06/09/2012

If you go to the reports layout and select Office 2, then the date value
list shows the following
- 06/09/2012
- 11/12/2012
- ?

I really can't for the life of me figure out why some dates will show in the
value list and others won't.

Please, please tell me I am doing something stupid here and I'm not actually
going insane!

Many thanks for any help you can give
Ed



#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>