Hello Everybody,
PHP Runner has been really useful everyday and everyday we explore the possibilities of the same.
I was working on a project, and i wanted your help.
I have two table (1) TRANSACT (Master) (2) TRANSDET (Details)
Now, the following are columns in each
TRANSACT:
TRNID
NAME
AMOUNT
DATE
TYPE
TRANSDET
DETID
TRNID
PARTNO
ITEM
PRICE
Now my Linking is TRANSACT.TRNID -> TRANSDET.TRNID
Now, here is my problem.
In the LIST page of TRANSDET
I want to display details from the Master table TRANSACT using the key TRNID
So that my LIST Page has the following columns also.
TRANSACT.NAME
TRANSACT.TYPE
TRANSACT.DATE
How should i do the same? Please help on the same.
Thanks in Advance. Looking forward for good ideas.