| Index
» Projects
» phpMyEdit
» Forum
» field lookup in two tables |
 |
bentuinstra
Joined: 12 Sep 2004
Posts: 29
Posted: 2005-04-06 08:39
Back to top
Reply with quote
|
Hi all,
I would like to read a field from another table and with the given result do a lookup in another table.
Here is a simplified table definition:
| Code: |
Table1:
ID1
NAME
STATUS
Table2:
ID2
DESC
STATUS
Table3:
ID3
NAME |
While viewing table1 the status field should be read from table2.status (this works). But in Table2 the status field is read from table3, where the real name is.
So when I read the status field from table2 I only get an ID, not the name which is in table3. Hope my description is clear enough.
Anyone an Idea if this is possible in PME?
Kind regards,
Ben
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2005-04-06 09:15
Back to top
Reply with quote
|
a little tweaking is needed...
http://opensource.platon.sk/forum/projects/viewtopic.php?t=103&highlight=table+lookup
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
