Welcome Guest, Not a member yet? Register   Sign In
Joining tables together in a model function
#6

[eluser]jpidgeon[/eluser]
CRITERIA TABLE

criteria_id JOINED
criteria_name
criteria_description
criteria_order
criteria_kpi1
criteria_kpi2
criteria_kpi3
criteria_kpi4
criteria_kpi5
task_id JOINED

DATA TABLE

data_id
qms_id
staff_id
criteria_id JOINED
kpi1
kpi2
kpi3
kpi4
kpi5
comments
develop
dev_action
dev_result
dev_target
dev_completed

TASKS TABLE

task_id JOINED
task_name


So I'm normally sending in the data.qms_id and criteria.task_id, which would return the 40 or so rows in the criteria table, but as there are no rows currently existing in the data table - nothing shows. Rows of data are only added here once I save the form.


Messages In This Thread
Joining tables together in a model function - by El Forum - 02-08-2011, 04:57 PM
Joining tables together in a model function - by El Forum - 02-08-2011, 09:26 PM
Joining tables together in a model function - by El Forum - 02-08-2011, 11:15 PM
Joining tables together in a model function - by El Forum - 02-09-2011, 06:25 AM
Joining tables together in a model function - by El Forum - 02-09-2011, 10:58 AM
Joining tables together in a model function - by El Forum - 02-09-2011, 11:57 AM
Joining tables together in a model function - by El Forum - 02-09-2011, 08:43 PM
Joining tables together in a model function - by El Forum - 02-09-2011, 08:53 PM
Joining tables together in a model function - by El Forum - 02-10-2011, 03:40 AM



Theme © iAndrew 2016 - Forum software by © MyBB