Value list based on a relationship in another file

[Dave E]

Hi guys...

I'm stuck...again! I have two files - an invoice file and a file containing a list of all possible services. In the service item file I have flagged some of the services as "hot" items and want to display these items as a value list in the Invoice file. I created a value list in the service item file that displays the "hot" items correctly (based on a relationship), but it won't display in the Invoice file...

I'm sure I'm being dim, but I can't figure out what I'm doing wrong. Please help...

Thanks

Dave

[-Queue-]

You'll need to create a value list in the Invoice file, either using the value list in the services file or creating a similar relationship to the "hot" flag in the services file and using values from a related field.

[Dave E]

I tried the first route... I must have done something wrong because the value list worked in the services file but not in the invoices file... your second suggestion worked a treat! Thanks for getting me going again...

Ciao

Dave