2. PHPRunner General questions
  3. [SOLVED]  Lookup Tables
This topic is locked
[SOLVED]

 Lookup Tables

 		4/29/2007 5:43:37 AM
PHPRunner General questions
H
 hlewis author

Hi,
I'm currently trialling PHP Runner version 3.1 Build 218. I am very new to the whole PHP/Database thing so forgive any ignorance displayed.
I'll try to explain my request in in simple terms. I have a table for accounts, a table for addresses and a reference table containing address information for the United Kingdom. The account table has an id column and then the usual name, e-mail, phone, etc. The addresses has the foreign key link of account id and then Address line1, address line 2, town, city etc. In theory an account holder can have multiple addresses. So when a user creates a new account, they should also be populating the address table with the address information linked by the account id. I've set up a table view for that and think I'm on the right track - if I'm not, please any advice would be welcome.
My main problem is around using the lookup tables. When the account is being created, through the table view I'm trying to set the address fields to point to and look up the data from the address reference table. The first part seems ok where I select the table, link field, display field and unique values. That tests ok. When I try to use the dependent feature, that's when it goes wrong. So the first look up would be County, followed by Town then postcode. Town should be dependent on County. For this the category control doesn't make sense because all it gives to me for selection are the fields from the account table and none of them work. I would've expected the category control options to be showing columns from the address reference table as well?
The next scenario would be a change to address details once the account had been created. This should then be supported by the edit page on the same table view so that the user could use the lookup function to select from the addresses they had already entered or create a new one. If someone could talk me through that I'd be really grateful.
I'm finding PHP Runner really useful as previously I had tried dbqwiksuite and am on the point of giving up with it. DBQWiksite I found to be too 'clunky', changes seemed to take an age to work through and page creation I found a bind. Also the forum is fantastic, no other way to describe it.
Many thanks
rsawchuk 4/29/2007

Have you taken a look at the tutorial on this topic at http://www.xlinesoft.com/asprunnerpro/flash/asp_depen.htm ?
Might be a good place to start.
I use dependent drop-down look-ups all the time and they work fine.
Russ
H
 		hlewis author 4/29/2007

Thanks for the response Russ.
I looked at the tutorial before hand and do understand the general principles behind the dependency rule. I don't know however if the problem is being caused by my use or set up of the table view. As I said I was expecting to see the columns from the second half of the view that would've been pulled from the addresses table. But it only shows me the account columns which do not provide the dependency?
Sergey Kornilov admin 4/30/2007

uniteegolf,
you can publish your application to Demo Account and send the URL along with problem description to support@xlinesoft.com. Without seeing your files and data it's hard to provide a meaningful advise.