Value List based on a Relationship

[Spurpurajr]

Hi All,

I have a project that I am working on and I guess I am a bit brain dead. I have a noequi join between the Consultant TO and ConsultantTime and I only want to show a drop down list of consultants with a particular customerTypeID. I think I have it but it still shows every customer type.

Any ideas what I am doing wrong. The database is a Consultant Time and Billing solution. I have attached the database for review.

Thank you, spurpurajr

SCPSolutionsTimePro.fp7.zip

[David Jondreau]

1) Change the relationship to remove the Consultant ID=ConsultantID criterion. If you need that for another feature, create a new TO and a new relationship based on just the TypeID to FilterID.

2) Open up the Consultants value list and check the "include only related values from"... ConsultantTime (or your new TO).

I think that should do it.

[Spurpurajr]

Thank you DJ! Perfect just what the doctored ordered.

spurpurajr