Displaying content from one table in another while in CMSB

Hi Joseph, 

This sounds like you're looking to set up related records. A related records field allows you to list records from another table that have a num value stored from the current record in another table. Here is a quick tutorial on how I set up a related record for my car/brand sections in my test CMS.

Firstly, a car has a brand record, and brand is chosen via drop down list (see list-settings.png). 

Next I create the related record field. To do this click the add field button while editing the section that needs to contain the extra records, in this example that is the brands section  (see add-a-field.png).

Next I set up the related record field, I select the cars section from the drop down, and then  update the MySQL where statement field with the field that stores the brand against each car (see related-record-field.png). I also checked the list action fields for the things I want users to be able to do from the list. In your case you might only want view.

Finally, I go to the brands section and view a brand record. Now my related records field lists all of the cars that are in that brand (see final-result.png).

Let me know if you have any questions.

Thanks!

Greg

Hi Greg

Excellent got it to work. 

I am looking to creating a CRM system to track all my advertisers etc. 

Joseph

Hi Greg

How did you create those blue tabs on the left hand side for your sections editors?

Joseph

Hi Greg

I  worked out how to create the Tabs. 

Thanks in advance. 

Joseph