I posted this in Ditto, but I think I should have come here first...
I am building an intranet site to manage my breeding birds and clutch data and so forth. I planned it out extensively so that I would be able to scale in the future but I have one little issue, here is a diagram (menu structure).
Summary Page *working - shows in house ref# and breed of bird
Pair1*stuck on this one - shows details on the pair and has a list of clutches with links
Cock *working - has bird specific data, band #, value, health notes and such
Hen *working - same as above
ClutchX *working - new page per clutch, simple date and band #
I have a tv [*breeder_sex*] as a list box for cock / hen but on the PairX page. I need to pull the first two pages and determine what one is the cock and hen, and make a link to those respectively. I have yet to enter much of the data but what I have so far is working. Not sure how to get this done... Really I guess I can make sure to create the cock and hen pages in the same order every time that way child one will allways be the cock. But since they are tagged with the above tv I should be able to set this up right so I don’t have to worry about that.