We currently have a website for our company where our customers can register for our services (training classes). We are trying to integrate the website registrations with our CRM (ACT) and QuickBooks. To do so, we need the online registration to be a Parent/Child relationship where the customer/Company has a Parent account and the employees that sign up are linked to that account but have their own as well.
For example, "Company A" has 5 students that will be taking our classes. So they create a company account and sign up their 5 employees (as students) for various training classes. In 2 months, another employee wants to register (as a student) and will need to enter the Company A's customer ID number to be linked to their company.
This is so we don't create duplicates in our CRM. We tried matching on Company Name, but there is no way to regulate what the students type in the field... sometimes "Company A", sometimes "Company A, Inc." and we don't want to put a dropdown list for Company Name that our competitors can steal.
Right now our website is hosted internally. We use WordPress and Event Espresso to run the site/events. The "Register" feature we use is actually WordPress's and it does not allow for Parent/Child memberships.
Any ideas on how to make this happen? Can we code an HTML registration system that will feed into a SQL table?