Hi,

I have a CheckOut database that looks up a value list of Items from an ItemsDescription db. There are more than 1 of some items, so I've created a field that creates a list of consecutive n+1 numbers (one on each line). I then made a value list of that field. What I want to do on the CheckOut DB is use the Items Value list as a lookup and, if there are more than one of that item, activate a lookup of the number list. How do I go about this?

p.s. eventually, it would be nice to deactivate any of the numbers on the CheckOut number list that are currently checked out (I already have a currently checked out items list). Again, thanks for all your expert help.

Peter

I'm not sure I exactly understand the question, but here goes. You can base a relationship upon your field with items on separate lines. This is called a multi-key. It will match multiple items in your Items Descriptions file. Performing a lookup based upon this relationship is a little tricky. A lookup to a single field will only bring across the data from the first match. A portal view will show all the records in Item Description matching the multi-key field.

I'm not exactly clear on what you want to do using this approach, but you can add or subtract realted items by adding or removing items from your single multi-key field (items separated by a carriage return). The multi-key field needs to contain not descriptions, but something like Item ID's to be useful in relating to records in the Item Description db.

-bd