Filter by WHERE

Hi,
I'm not sure that I understand your question.

Please re-phrase it.

OK, I have a table called Boilerservice.

In this table I have about 45 fields.

I also have a table called reports which has about 500 fields.

On the Boilerservice table, I want to add the information into the fields using dropdown boxes which are linked to the fields on the report table.

There is a field on my Boilerservice_add page called JobSheet.

There is also a field on my reports table called JobSheet.

So, on the boilerservice_add page, the user selects "A" from the dropdown box for JobSheet

So, On the visual editor, I am using the lookup wizard, this looks at the report table and shows the JobSheet "A", "B", "C" and so on.

I only want it to show "A" when the user clicks on the list page with search. At the moment, it will show "A", "B" and "C" jobs to pick from

Cheers

Paul

Hi Paul
I don't fully understand exactly what you mean but I have a where on the lookup as follows which I think might give you the help you need to solve...

"username = '".$_SESSION["UserID"]."' and activity_status <> 'A'"

Deos this help - sorry if not.
Gareth

Cheers gareth.
When I add a job in the boilerservice add page, I have a filed called Jobsheet which I can select A, B, C or D.

The next field is the LastFimeno.
In the picture I put in, I am editing the LastFileno

It is looking at the table called report.

The link field is the reportGuid, but is displays the File No which is in the field R001 so the user can make sense of it.
Its dependant on the OrderSite Address_R004 in the Boilerservice Table matching the field R004 in the reports table, which hold the same address.
now, when I look in the reports table for the order site address (R004) I have four entries, These all have different Jobsheet types A, B,C and D.
SO I want it to only display the same Jobsheet in the lookup wizard as in the Jobsheet selection on the boilerservice which was selected before hand.
So, When we add to the boilerservice page, we might select Jobsheet B.
WHen we select the LastFileno, it would show 4 lists to pick from, all with different Jobsheets, A,b,c,or D, but as the user has selected Jobsheet B I only want it to show Jobsheet be from the list to select.
Cheers

Paul.

Unfortunately PHPRunner do not support dropdowns dependent on two fields.