This topic is locked

Want Fields From Master Table

4/7/2006 7:12:53 AM
PHPRunner General questions
H
handsomeabhi author

Greetings,
I recently came to know about this product PHPRUNNER 3 and I got more than I had asked for.It's been 4 days now I am evaluating your great product.
So here I am posting a problem(for me) which needs to be solved.
I can explain you what I want , with this small example.
I am using ORACLE 9i database.
These are the details of the two tables.

CREATE TABLE MOVIE(

"MOVID" NUMBER PRIMARY KEY,

"TITLE" VARCHAR2(25),

"GENRE" VARCHAR2(20)

);
CREATE TABLE TICKET(

"TICID" NUMBER PRIMARY KEY,

"MOVID" NUMBER REFERENCES MOVIE,

"TICDATE" DATE

);


So field "MOVID" is the PK in MOVIE table which is a FK in TICKET table.
I did exactly as told in your software for the master detail relationship.
But what I want is the when I add a new record in the TICKET table, I should have a dropdown list for the MOVID field in TICKET table which will caontain all the MOVID's of the records from MOVIE table.
At present here is the ADD NEW ITEM table for TICKET table


but what I want is this


I hope you have understood what I want to be done.I am NO PHP coder, so I cannot do it myself.
I am sure you will help me out as I am looking forward to purchase PHPRUNNER 3 for all my PHP database website needs <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2731&image=3&table=forumtopics' class='bbc_emoticon' alt=';)' />
Best Regards,

handsomeabhi

Sergey Kornilov admin 4/7/2006

Hi,
you can do it using LookUp Wizard option.

Proceed to the Formatting Tab (Step 7), select Lookup wizard for movieid field in the Edit as dropdown box, choose Lookup table and set Table, Link field, Display field etc.

H
handsomeabhi author 4/7/2006

Greetings Sergey <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=8959&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> ,
Thanx A Lot for your quick reply.
I tried what you said but I get this error


Waiting for your reply <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=8959&image=3&table=forumreplies' class='bbc_emoticon' alt=':)' /> ,
Best Regards,

handsomeabhi

Sergey Kornilov admin 4/10/2006

Hi,
please zip and send to support@xlinesoft.com the full set of generated PHP files along with your database creation script.

I'll find what's wrong running your project on my test box.