Is there a simple way to set up a many-to-one relationship where multiple field values need to all match? In this case, we have an HTS program organized by microplate barcode, row, and column. I'd like to be able to bring up a unique structure from a separate table based on a match to these three criteria.
So you would also have those 3 columns in the structure table?
This is not possible as relationships are currently restricted to a single field/column. However that column can be a text column (I just tested this and it seems to work OK), so potentially you could concatenate the 3 values into a single column for both tables at the database level (e.g. using triggers) and then use that value for the relationship.
Simpler through would be if you could include the compound ID as an additional column in your table, then you could use this directly.
Longer term we do plan to support fields that use multiple columns (this was one of the key reasons for the Field abstraction).