Pesky inventory problem involving lists

[jim lee]

I have three files, well actually more than that, but these three are the pertinent ones.

Parts - Data on everything I buy, build, or sell

Inventories - The different inventories that parts can be found, built or shipped from.

Part Location links - Links Parts to inventories. Basically part ID, Inventory ID & Qauntity in stock. (Among other location specific things)

I'm sitting in inventory #1 looking at a portal of all my parts (part links) I'd like each part to have a popup menu. Fine, this is no problem.

I would like this popup menu to show me the possible places in -this- inventory where I stashed this particular part. IE "Box on top shelf". I need it to be editable by the guy looking at it.

I -don't- want to see where this part could be stashed in inventory #2 "Under Bob's desk"

"Who's Bob?"

"C'mon, you know.. Bob's that joker in inventory #2 that keeps stashing stuff under his desk!"

I first thought, repeating field! But that just gave me all the categories mixed together, no good. Is there a solution?

Thanks!

-jim lee

[kennedy]

I think you want a self-join relationship matching on the inventory key. Then gen a conditional value list on the where-is-it field using that relationship ("Only Related Values" option).

See threads on "conditional value lists" for more info.