Value list Question

[Mike J]

Hey everyone,

I need assistance grasping the List concept to generate a conditional value list a user will use to place a sample in a lane on a gel. I will take a sample (Unique Sample ID) and put it into a specific Lane in the gel (Lanes 1-12).

I have two tables: Samples and Gels. From the Gels table, I look at two related tables [samples and Gels[2]] for list calculations within the Gel Table.

List (All samples associated with this gel) [looking into the samples table by way of Gel ID in the sample record]

List (Samples that have been put into a lane on this gel)[looking into a second occurance of the gel table to find which samples have been loaded into the current gel]

My third list is the one the user will use that conditionally provides those samples remaining to be loaded into a specific lane. Once all samples are loaded, this list is empty.

Any suggestions on how I make this third list?

Thanks

Mike

[Mike J]

Nevermind, found my answer on JMO's site.