Your equipment_type field looks like it's set up correctly.
Thanks, that's good.
Oh, Equipment Type is showing as a number on the list page! I thought you meant that you had this behaviour on the add/edit record page.
Actually, the problem IS on the add/edit record page. I've attached a newer screen shot with a red arrow and text pointing out the problem in the equipment type column of the inventory section within CMSB admin
I'm not sure we have support for displaying multi-value fields' labels on the list page, but it's probably something we could do pretty quickly through consulting.
Actually, If you mean the record list page inside the cmsb admin panel, I've never had a problem doing this. In fact, it's working right now on a couple sites that go back to version 1.23. I don't think it's a consulting kind of thing. I think where a problem may occur, especially for a newbie like me that's not a MysQl type programmer is when references need to be made to other sections from a different section's viewer or table.
Also, in the Inventory section editor, you can set the default sorting under the Sorting tab. After changing this, you can get rid of the dragSortOrder field.
Thanks, I used this to modify the manufacturer and equipment type order display, but in their own respective sections and not in the inventory section. So now when a record is added to inventory the manufacturer and equipment type dropdowns are in alphabetical order.
Does this mean you're no longer having problems with Equipment Types which have spaces?
This has been corrected...
...however there is still an issue or two relating to the functionality of the cool plugin. So, let's wipe the slate clean and I'll list the challenges below:
1. As mentioned in previous post and reply above...when on the inventory section record list screen (going to add/edit inventory records) the equipment type column displays the number and not the title of the equipment types. The manufacturer field works fine, displaying the name of the manufacturer. As mentioned earlier, screenshot is attached for your review and you have login details.
2. Issue not recognized before but related to the plugin issues and MySQL. When adding/editing an inventory record, if no manufacturer, model or equipment type is chosen then when a visitor clicks on the inventoryDetail.php page, they get a MySQL error that reads:
"MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) ORDER BY title' at line 3"
My guess this is a result of the viewer code you provided was not taken into account that these fields might be absent in a record:
// load referenced records for our fields
beta_lookupRelatedFields(array(
'table' => 'inventory',
'recordList' => &$inventoryRecords,
'fieldList' => array(
'manufacturer', 'model' => 'model', 'equipment_type'
),
));
The client does not want the manufacturer, model and equipment type fields to be set as 'required'.
Thanks for your help.