Random Pick, but grab identical records

[vgersghost]

I need to randomly audit parts in a warehouse. I have the code to grab random records. No problem there. The problem is the part might have mutiple locations, so I need a way to grab a random part and then check to see how many locations it's in and make sure it grabs all other locations that part is in.

Example 10-67140 might be in locations L1345 and T6789

Its a one to many. One part mutiple locations.


thank you

 

[WayneRyan]

vg,

If it's no problem to grab a random parent record, then all you have to do
is query with a Left Join and you'll get all its associated locations.

Wayne

 

[vgersghost]

Thanks

Left Join works great. Such a simple solution.

 

[WayneRyan]

vg,

Glad to hear it.

Wayne