cmendla
Member
I need to connect to existing Jbusinessdirectory tables via fabrik. There is a company-categories table that isn't getting updated when we add a company. My solution for now is to create the company and then add the entries to the table manually.
I created a list called company maintenance. That uses the _jbusinessdirectory_companies table.
The join is to company-categories which has the following structure
# Name Type Collation Attributes Null Default Extra Action
1 companyIdPrimary varchar(11) utf8_unicode_ci No Change Change Drop Drop
2 categoryIdPrimary int(11) No None Change Change Drop Drop
The join is a left join on companies to company-category
I need to have the ID of the company record show in the form. That is the ID of the jbd-companies record
1 idPrimary int(11) No None AUTO_INCREMENT
I'd appreciate any thoughts on this.
Just to rephrase: (jbd = j-businessdirectory)
thanks
chris
I created a list called company maintenance. That uses the _jbusinessdirectory_companies table.
The join is to company-categories which has the following structure
# Name Type Collation Attributes Null Default Extra Action
1 companyIdPrimary varchar(11) utf8_unicode_ci No Change Change Drop Drop
2 categoryIdPrimary int(11) No None Change Change Drop Drop
The join is a left join on companies to company-category
I need to have the ID of the company record show in the form. That is the ID of the jbd-companies record
1 idPrimary int(11) No None AUTO_INCREMENT
I'd appreciate any thoughts on this.
Just to rephrase: (jbd = j-businessdirectory)
- I created a list that uses an existing jbd table
- I linked that table to the jbd-company-category which is a two column table - company id, category id.
- the left join is from company.id to company-category.company_id
- There will be cases where the company does not have a corresponding company-category entry. The purpose here is to enter that manually.
- The list shows what I need: Name, company.id, main_subcategory (category).
- When I click edit, I see everything I need EXCEPT the company ID.
thanks
chris