I’m new to suitecrm and I’ve been searching through the forums but haven’t quite found this scenario…
I have 2 custom modules - One is Workorders and the Other is CustomerLocations.
I have a many-to-one relationship between workorders and customerlocations.
I have a field in workorders that is type Relate called Location that relates to the customerlocations table.
The customerlocations table has a text field called LocationID
When I edit the Location field in workorders, it pops up the list of customerlocations and when I choose a location, it leaves the location field blank.
I deleted the built in name field in CustomerLocations module and I think that is what suitecrm is trying to populate the workorders LocationID field with.
How can I get it to populate the locationID field with CustomerLocations Location field instead?
Here is what the editviewdefs.php file has for that field:
1 =>
array (
'name' => 'w_workorders_c_customerlocations_name',
),