slbr549 Posted November 10, 2000 Posted November 10, 2000 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.
LiveOak Posted November 11, 2000 Posted November 11, 2000 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
slbr549 Posted November 11, 2000 Author Posted November 11, 2000 Thanks so much. This worked perfectly. I believe I was trying to make it more difficult than it had to be. Thanks again.
Recommended Posts
This topic is 9030 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now