Value List and TO Relationships

[Rich K.]

Hello -

I have a table called DocType with the following fieds dtID (num) and TypeName(text). I have created a Value List called vlDocTypes from this table.

I have another table called Vendor it has all the normal fields you would expect and then it has the following 3 fields: dtID_purchase (num), dtID_creditmemo (num), and dtID_payment (num). As you would guess each of these are supposed to have values from vlDocTypes.

Now, I can of course could have 3 different TOs (of the DocType Table) for each of dtID_xxx fields... However is there a way to do this with a single TO relationship between Vendor and DocType?

Thanks

Rich

[bcooney]

It's not the relationship btw Vendor and DocType. What you really want is three DocType value lists.

Here's a demo.

Edited January 12, 2010 by Guest