I am designing a DB for Reader Service Cards. I am allowing the user to click on several values for one field. (i.e, 1, 30, 40, etc.). I need to relate each of the numbers clicked to a specific vendor for merge letters.

Does anyone know of an efficient way to "split" the fields so the relationship will work?

Thanks.

A relationship based upon a text field with multiple values will work. for instance, if the field has the values:

1

30

60

(carriage returns are part of the field). A relationship can be built and will show the related records for the values 1 and 30 and 60. If this is not what you want, you will need to 1) create enough calculated fields so that each can hold one number (30 field would allow a max of 30 entries), 2) create one calculated field for each possible value (slightly different approach), or 3) create records in a second file, one record for each entry and relate the records in the second file to the related file. Number 3) would be done using a script. -bd

Thanks so much. This worked perfectly. I believe I was trying to make it more difficult than it had to be.

Thanks again.