2. ASPRunnerPro General questions
  3. Show more than only ONE Lookup-Field
This topic is locked

Show more than only ONE Lookup-Field

 		2/8/2005 10:00:23
ASPRunnerPro General questions
Pfeiffer author

Hello,

do you have an idea to solve the following problem.
a) Database MYSQL (with no views !! because 5.0 is a alpha release and not stable)
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1113&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> a table Cutomer and a table bills connected with Cutomer_ID
c) I show a table with all bills and want to show the customer

PRENAME AND NAME AND CITY !! in the SAME view screen.

I don't want to edit these fields.
Using LOOKUP I can only show one field, for example PRENAME. But this is not

sufficient, because many people have the name Bill...
So how can I show these additional fields in ASPRUNNER ??

Can I defined additional fields in SQL-Query which are not part of the table ?

If I do so, the manipulated SQL-Query is reset by reloading the project.
Thanks

uwe
Sergey Kornilov admin 2/10/2005

Hi,
the one way of solving your problem are joined fields. You can make your custom SQL query at Edit SQL query tab, for example:

select 

...

customer.prename as prename,

customer.name as name,

customer.city as city

from bills

inner join customer on customer.id=CustomerID


We're now working on project reloading problem.
Pfeiffer author 2/10/2005

Yes, joined fields solve the problem, but as I told you before

ASPRunner rebuilds my Query and destroys my changes.
I thinks thats the problem.
So I can not use an expression with joined fields.
Sergey Kornilov admin 2/11/2005

We're now working on this problem.