cimbur39
Joined: 22 Sep 2008
Posts: 1
Posted: 2008-09-23 19:00
Back to top
Reply with quote
|
All I'm trying to do is this:
I have 2 tables "tbl_group" and "tbl_subgroup".
tbl_group
- group_id
- group_name
tbl_subgroup
- subgroup_fk_group_id
- subgroup_id
- subgroup_name
Now, I would like to display a dropdown with subgroup_id values.
However, for the description of the items, I would like to use "group_name - subgroup_name".
Getting the description to show "subgroup_name" alone is no problem but, I cannot for the life of me figure out how to include a filed from another table in the description as well.
I played with joins and filters (I understand filtering is the way to go with ACP).
Any help would be much appreciated (exact syntax would be amazing)
Thank you.
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
