Linked records ?

In a moment of clarity brought on by the sedative from my tooth extraction today, I guess I only need to create a link on the breeding page to the relevant availabe records.  Any ideas how I would achieve this ?

Hi Rewmer,

I'm not sure exactly how your sections work (can you list the fields in each here?), but creating a link between two sections typically starts with creating a List Field with List Options = "Get options from database (advanced)", then you select the other table and the fields to use. It's almost always a good idea to use "num" as the value field. It's also much simpler to use the Display As "pulldown" or "radio buttons" option (not the "pulldown (multi value)" or "checkboxes (multi value)" options)

Which table you create the List Field in depends on whether single records in table A are to be associated with multiple records in table B, or if single records in table B are to be associated with multiple records in table A. If I understand your explanation above, a snake breeder would own multiple snakes-for-sale, therefore you would want to create the List Field on the snakes-for-sale table (you can call the List Field "Snake Breeder"). Then, when adding a snake-for-sale, you would select the breeder who's selling it from the pulldown.

Please let me know if this helps or if you have any questions!

Anyone have any thoughts on this ????

Hi Rewmer,

I think I understand. You want to add a link to each "incubator" section record listed on http://www.genetic-gems.com/pages/royalincubator2013.php to a page that shows the "available" section record with the same Clutch No..

Check this out: http://www.genetic-gems.com/pages/royalavailable2.php?clutch_no=9

CMS Builder automatically (by default) allows list pages to search on any fields; therefore, adding a link inside your foreach in royalincubator2013.php like this should work:

<a href="royalavailable2.php?clutch_no=<?php echo $record['clutch_no'] ?>">See available animals</a>

Note that you will need to change the $record variable name to the same variable name as in your foreach loop. It's probably something like $breedings_incubatorRecord.

If you run into any trouble or I misunderstood your requirement. Please attach the source code of your pages so we can see what your section names, field names, and variable names are.

Hope this helps!

Thanks Chris, I will have a play with that and see how I get on. Sounds like the badger!

Beautiful !

Works a treat, just what I was after Thanks very much Chris.

Thinking along the same lines, I tried to get it to link direct to the details page by

By doing this <a href="royalavailabledetail.php?clutch_no=<?php echo $record['cluth_no'] ?>">See available animals</a>

 but to no avail. Is this possible ? (oh and the variable "cluth_no" is spelled correctly - typo when I set up the DB)

Andy

Been playing with this all weekend and still can't get it. Any suggestions to get the link through to the details page ?

Andy

Hi Andy

Could you post a copy of your detail page for me to review? Or at least paste in a copy of all the PHP code at the top of the page. 

Thanks!