SecureCloud
Posts: 51
|
Posted: 12/24/2012, 9:44 AM |
|
I am still learning CCS as to just plain php...
i have looked all thru the forums, and noticed all the posts i was looking at were from 2009.
that was maybe CCS 3 or 4.. alot of the problems have been taken care of,
and are now included in CCS 5...
i could not find an answer, so please forgive me if this seems like a n00b question.
i am using CCS5 & php & MySQL.
finally, onto my question...
i have 2 tables.
1.) (EMPLOYEES)
emp_id
emp_name
emp_phone
...
2.) (EXPENSES)
exp_id
emp_id
exp_type
...
now, CCS seen the same " emp_id " in both and automatically related them.
the setup i want is to be like this...
the employee has its own form that gets filled in.... expenses are added later after the employee is created....
then.... (the employee part i got and works fine)
its setting up the expense part, using both tables
the expense form uses the emp_id,
( so i used the query builder and added both tables, just using emp_id from employees, and everything from expenses.)
so when i list expenses in a grid, i want the emp_id to be associated with the expenses.
the first problem i am having is...
when creating the expense record builder form, there is no query builder ?? to be able to add both tables...
do i have to make all my Queries first, then save them ? then add those in place ?
because if i cant use both tables, then its not gonna tie the employee to the expense.
next when i create the grid for the expenses, i can use the query builder, but if i cant add the records the right way
then it wont display right.
ALSO, when creating the grid, and using the query builder,
it creates in fields for grid part... employees.emp_id ... (do i have to leave that in, is that the connector one,
because emp_id , exp_id are ALSO listed)
here is the sql it creates...( i prolly only need the emp_id, i also added the emp_full_name.. i dont need that...)
SELECT employees.emp_id AS employees_emp_id, expenses.*, emp_full_name
FROM employees INNER JOIN expenses ON
employees.emp_id = expenses.emp_id
can someone please explain in the dummies version of using GRID and RECORD using MULTI-TABLES
using CCS 5.
i have also read alot about the data dictionary, do i have to preset everything in there and save as query ??
_________________
-------------------------------------------------------------------------------------------------
If this helped You, Please Donate to SecureCloud Here, ANY amount Accepted.
http://securecloud.biz/donate/
Thank You, Your help Keeps us Going.
|
|
|
SecureCloud
Posts: 51
|
Posted: 12/24/2012, 9:47 AM |
|
after posting this, i got this error on forum... just a white page and this.... wierd..
240 Article posted <550d8942ca6003@news.codecharge.com> Value ERROR! BulkMail(): Could not send the email. Failed at 'mail' command.
_________________
-------------------------------------------------------------------------------------------------
If this helped You, Please Donate to SecureCloud Here, ANY amount Accepted.
http://securecloud.biz/donate/
Thank You, Your help Keeps us Going.
|
|
|
SecureCloud
Posts: 51
|
Posted: 12/24/2012, 11:06 AM |
|
i (SOLVED) it.
i think because codecharge auto seen the (2) emp_id fields, that it worked out.
but what if they weren't auto seen ?
i wanna see if anyone could give a basic tutorial on RECORD multi-table ??
then i will (solve) this, or if no one does i will solve it.
but i think alot of people could use an updated tutorial geared toward CCS 5
_________________
-------------------------------------------------------------------------------------------------
If this helped You, Please Donate to SecureCloud Here, ANY amount Accepted.
http://securecloud.biz/donate/
Thank You, Your help Keeps us Going.
|
|
|
sumanrocksu
Posts: 3
|
Posted: 01/25/2013, 5:42 AM |
|
i also need help on this issue.....i have a customer table and few other tables related to that customer table......in my page I have a customer form below that form few tabs.Customer form will insert data about customer into customer table and each tab consists a unique form which will also insert data about the particular customer in other tables related to customer(say customer_contacts,customer_details).....please tell me how can i solve it.......
|
|
|
sumanrocksu
Posts: 3
|
Posted: 01/25/2013, 5:56 AM |
|
Quote SecureCloud:
i (SOLVED) it.
i think because codecharge auto seen the (2) emp_id fields, that it worked out.
but what if they weren't auto seen ?
i wanna see if anyone could give a basic tutorial on RECORD multi-table ??
then i will (solve) this, or if no one does i will solve it.
but i think alot of people could use an updated tutorial geared toward CCS 5
plz i also need a solution.....reply.....
|
|
|
|