The Conditional Value List Blues

[Sari]

Hi,

I thought I had this tucked under my belt but seem to be having a problem!

I have a layout based on tbl_Quote and when I input a company code I want to be able to choose a Job No which is related to that company.

I've attached my relationship diagram and the value list dialogue box.

Incidentally, I'm using a trial upgrade to Pro 8 until the CD arrives - just can't wait.

Many thanks in advance.

Quote_Job_No.pdf

Quote_Relationship.pdf

[Kip]

Looking at your attachment you based your relationsship for your valuelist on the value that you want to generate. I don´t think that will work...

[Sari]

Thanks for looking Kip. What do I have to do with my relationships to make this conditional value work?

[Kent Searight]

You'll need a companyID in a table occurrence based on Quote relating to a companyID in a table occurrence based on Job.

Think about it...the companyID is the perspective through which you want to view related Jobs from Quotes.

See the attached sample. If you create a new record in Quotes and enter a valid companyID, the JobID field will show a dropdown list of jobID's that are associated with that company.

JobsFromQuotes.zip

Edited October 19, 2005 by Guest

[Sari]

So many thanks for that. I can see it now .... til the next time!! :blond:

[Sari]

Whilst I found this works, I can't help worrying that this solution creates a many to many relationship. Don't I have to worry about that? :qwery:

[Kent Searight]

Whilst I found this works, I can't help worrying that this solution creates a many to many relationship. Don't I have to worry about that? :qwery:

In "real life", one of the companyID keys would be a unique, auto-entered ID, making it a one-to-many relationship. The example is very simple and doesn't have that, so that's why it shows as many-to-many.