2. PHPRunner General questions
  3. Multiple joins for dropdown
This topic is locked

Multiple joins for dropdown

 		4/15/2009 3:03:36 PM
PHPRunner General questions
M
 MaxxaM author

I've search and tried to no avail on this particular issue.
I have a mfg table with mfgID and mfg_name, then I have an equipment table with mfgID, equipModel, serialNum, and locationID. Now I have a transactions table which tracks where the equipment moves. Very general here, but you should get the idea...
I know I can concat for fields in the same table, and I've tried the custom view thing, but the lookup table under the Edit As tab only looks at tables and not views that I've created. How can I have the lookup look at the view...or how can I concat fields from multiple tables so that my dropdown will have all the equipment details associated to it's unique ID(meaning mfgName, model, serial# and location). I store that unique equipID in the transactions table...
Any help would be greatly appreciated, we just purchased this product last week, I really enjoy it but need some pointers...
M
 		MaxxaM author 4/15/2009

Upon further investigation, the lookup table will pull in views created at the database level. I assumed that if I created a Custom View with PHPRunner that it was the same as creating a view on the database..it is not. At least not with mySQL and PHPRunner.
I think I've answered my own question, but further comments or suggestions are always welcome.
vin7102 4/15/2009

Hi MaxxaM,
Is your Mfg table and Equipment table set up as a master/detail relationship?

I've done a few setups similar to what you are describing and linked the id's of the two tables in the datasource tables page. In your case, I would add a "mfg_name" field to your equipment table and when creating the database link, set an <id to id> link and then a <mfg_name to mfg_name> link. Now, all of your fields will be in the detail view and will all be a product of the master id record and you can work with it much easier when its all in one table!

At this point, you can set up your list and report pages to show only the fields that you want to show but the other info will still be there in the database for your concat functions if you want.
Hope it helps

Vince
M
 		MaxxaM author 4/15/2009

Ah...I didn't think about that... I would try it out now, but some things just have to wait. I'll try it out tomorrow and let you know how it goes! I appreciate the input! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=40189&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
vin7102 4/15/2009

No Problem Maxxam, Hope it works out.

Welcome to the forum by the way!

Its a really great product and the support from xlinesoft and the forum users is second to none. You will always get the help you need from these guys.
Take Care