2. PHPRunner General questions
  3. Table look up
This topic is locked

Table look up

 		6/1/2008 03:27:46
PHPRunner General questions
S
 swanside author

I have the following tables and fields
customer.`Customer_Name`

customer.`Billing_Address`

sites.`Customer_Name`

sites.`Site_Address`

sites.`ID`

job.`Job_No`

job.`Customer_Name`

job.`Order_Site_Address`
In customer.`Customer_Name` I have about 30 customers with Billing address
In my sites table I have selected the following
Customer_Name = customerA, and customerB

Site_Address = site1A, site2A and site3A site1B, site2B and site3B
In the lookup wizard In the boxes I have the following
Table = sites

Link Field = Customer_Name

Display Field = Site_Address
This dropdown is dependant on

Catagory Control = Customer_Name (which is coming from the job table)

Catagory Field = Customer_Name
When I test it, it works, but when I build it, It wont work?
Any ideas please?
Cheers

Paul
S
 		swanside author 6/2/2008

Ok I have tried something different
I double click on my Order_Site_Address which is in the job table
I select the Lookup wizard and select lookup table

In Table I have sites

Link Field is site_address

Display Field is site_address

Order By is site_address

unique values is ticked

allow to add new values on the fly is ticked

This dropdown is dependant on

Catagory control is Customer_Name from the job table

Catagory Field is Customer Name from the site table.
When I test it, it works, but when I build it and try it, it wont work??
Here are my three tables involved.

The aim is to click on order_site_address and pick from the list which is selected from the customer name.
J
 		Jane 6/2/2008

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
S
 		swanside author 6/2/2008

Thanks Jane, just uploaded it and sent email.
Paul.
S
 		swanside author 6/2/2008

Its OK.
I have made a custom view to do the trick
Thanks

Paul