aslan
Joined: 22 May 2004
Posts: 5
Posted: 2004-07-12 23:25
Back to top
Reply with quote
|
I have 3 tables, on that is being populated.
The other two are related through and id so the tables are similar to this
Table 1 (table to be populated)
ID
Name
Type_ID
Table 2 (Where Type_ID is pulled from)
Type_ID
Type_Name
Cat_ID
Table 3 (Where Cat ID from tbl 2 is pulled)
Cat_ID
Cat_Name
For table one I want to display the Type_Name & Cat_Name in a pulldown to populate Type_ID in #1.
Reason some Categories have Types that have the same name, but the data in those types remains different.
Thanks,
A
|
pakman
Joined: 09 Jul 2004
Posts: 5
Posted: 2004-07-13 15:53
Back to top
Reply with quote
|
i've got similar problem.
I've tried join, [description] etc and it doesn't work.
I only want to build the f*k*ng description from the fields of other tables. I don't know why in the description array is impossible to make relation to another table. If 'description' wasn't a query to a table, maybe with simple coding i can made it making another query to db and writing it manually. But not, the 'description' field can be only a forced query to the [value][table].
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
