Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Website User Registration (Parent/Child Relationship)

Posted on 2014-04-14
3
Medium Priority
?
258 Views
Last Modified: 2014-05-15
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?
0
Comment
Question by:Daniellefischer
  • 2
3 Comments
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 2000 total points
ID: 40000541
and will need to enter the Company A's customer ID number to be linked to their company.

If this exists and is in the hands of the Company, it can be added to various WordPress forms and store in the wp-usermeta table.  That should allow you to run queries in a parent/child manner.
0
 

Author Closing Comment

by:Daniellefischer
ID: 40068393
Thanks, Jason. That is what we are ending up having to do. Was hoping there was a pre-built platform for this type of registration.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 40068473
Unfortunately, not to my knowledge.
0

Featured Post

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question