"Having set up these relationships, Even if I'm looking at the record for take 2 or 3, I only ever see the take information for Take 1."
You don't tell us what layout you are using to view your take records. What table is it based on? Are the take records displayed in a portal?
I am in a layout based on the codebook table and it's showing me the proper Datalog information (not portalled...) But not the proper take information (also not portalled).
If I'm going to portal, how do I get the record for take 1 to only show the portaled information for take 1? I don't want a list of all takes and their info.
"how do I get the record for take 1 to only show the portaled information for take 1?"
More important question: How do you get the record for any one take if your layout is based on Codebook? Any given record in codebook doesn't appear to relate to any one take, but instead, appears to relate to many take records.
I guess I don't describe things very well.
But I am happy to report I solved my own problem by relating setupID and TAKE in the Takes table to setupID and Take in the codebook.
If time permits, I'll explain more fully and perhaps a more elegant solution exists. But for now, Cheers and thanks. You're an excellent resource PhilModJunk.