> In article
> e53g2000hsa.googlegroups.com>,
>
>
>
>
>
> Diego B wrote:
>

>> Well, actually

>

>> I have two different situations:

>

>> 1) One table in the full DB (so included in the same file), reporting
>> value lists and working (NO relationship with anything else here )

>

>> 2) One new .fp7 file with only one table (so not included in the full
>> DB), reporting the value lists (NO relationship with anything else
>> here) that is not working.

>

>> In other words, whern the value lists table is in the same file, it
>> works, even without relationship defined, when i put the value lists
>> in a table on a different file it does not work.
>> The question is: do you think I should report the ID i use for the
>> relationships in the main DB, also in the single table file with the
>> value lists ? This sounds wird to me, but above all, very
>> uncomfortable (I have to create hundreds of new records in the sinlge
>> table file...)

>

>> Thank you for the help !

>

>> Diego

>
> Is the Value List getting data from records or from a pre-typed Value
> List in the other file??
>
> If you're wanting the Value List to display data from ALL the records
> in the other Table (rather than a subset of them) then you don't need a
> Relationship. This type of Value List would be defined as "Use values
> from field" rather than "Use value list from another file". Once you've
> chosen the other file you should be able to choose a Table / Field
> within it to get data from.
>
> If you trying to retrieve a pre-typed Value List (ie. one typed
> directly into the Define Value List window), then it will be the "Use
> value list from another file" option. That should allow you to choose a
> file and then a Value List to copy.
>
> There could be a hiccup here if you're trying to retrieve a Value List
> from another file, and that second Value List is defined to obtain it's
> data from records in another Field / File / Table ... I've never tried
> to "double-jump" a Value List that way.
>
> Helpful Harry                  
> Hopefully helping harassed humans happily handle handiwork hardships  ;o)- Hide quoted text -
>
> - Show quoted text -