Lookup table - category control

What exactly is the question?

Sql query looks like this:
select `table1`.`id_table1`,

`table1`.`a1`,

`table1`.`a2`,

`table2`.`b1`

From `table1`

inner join `table2` on

`id_table1` = `id_table2`
In step 8 table1, field a1 I setup as lookup wizard.

I select This dropdown is dependent on ...

On category control I can't find field b1 from table2, only fields from table1
It is possible setup b1 as category control?

I see what you saying now.
Category control should be a field from the same table. PHPRunner cannot update fields in two tables simultaneosuly, all updatable fields should come from the same table.

Hi
But field b1 from table2 is using only for reading data as category control for other fields from table1.

How can I solve it?

I can recommend to create a dummy field in table1 to store category name. You can hide this field on list/view/search pages.
We'll add a feture in the next version of PHPRunner that simplifies creating dependent dropdowns when category field is not in the same table. Currently you can use a workaround I have suggested.

Hi
How can I fiell this dummy field automatic not manually?

Any idea?

This dummy field will be filled automatically. There is nothing to do manually.

I don't know haw can I do this.

Can you help me?

Hi,
this dummy field will be filled automatically for newly added records.

To fill dummy field for existing records use the following query:

OK this query ->

updates existing records, but how looks query that works with Phprunner and works automatically when adding new record???
Now query looks like this:

Hi,
I'm not sure I fully understand your needs.
Please clarify what field you need to fill automatically, when it should be filled and what value should be written to it ?

What functionality do you expect from these dependent dropdowns ?

Give me some real life example.

Hi
Example:
Master Table Orders

Id_Order

Order

Assortment
Detail table Production

Id_Production

Order_P

Assortment_Part
In Phprunner for table Production SQL query looks like this:

Now field Assortment_Part I setup as Lookup wizard

and I need setup Assortment as Category control for this field.

But I can only using fields from table Production as Category control.
Is it clear?
Your suggestion is add for table Production dummy field that will be hold assortment. This field will work as category control. But how fill this dummy field automatically when I try add record for table Production?

If table Order holds Assortment value you do not need category control at all.
Instead of that you need to use WHERE expression to filter drop-down box content.
Here are required steps:

1. Do not use INNER JOIN query. Use default query PHPRunner builds for you
   
2. Define Master-Details relationship
   
3. Make sure Master table info appears on Details table list page
   
4. Save Assortment from Master table in Session variable (Production_list.php)
   
   see my changes in bold:
   

   <?php
   

   
   if($rsMaster)
   
   {
   
   $data=db_fetch_array($rsMaster);
   
   $_SESSION["Assortment"] = $data["Assortment"];
   
   ?>

5. When you define a lookup wizard for Assortment_Part field use WHERE expression:

"assortment_id = " . $_SESSION["Assortment"]

Hi
This not work. $_SESSION["Assortment"] always empty

When I setup to test

dropdown list for Assortment_Part work OK.

When I setup to test

and

dropdown list for Assortment_Part NOT work.
I think problem is more complicated.

When I add new record for Production I don't know what Assortment will be.

Assortment will be know when I choose Order_P(Order_P from Production = Id_Order from Orders) from dropdown list.

Zavka,

1. If Assortment field is a text field you need to add apostrophees while defining WHERE expressions:
   "assortment_id = '" . $_SESSION["Assortment"] . "'"
   
2. Did you setup a Master-Details relationship between Order and Production tables? This schema will work only if you use Master-Details relationship.

I found this:

When I go -> Detail table Production -> Add record - dropdown list for Assortment_Part NOT work

When I go -> Master Table Orders -> Detail table Production for any record from list -> Add record - dropdown list for Assortment_Part WORK OK

What do You think about? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=5277&image=1&table=forumreplies' class='bbc_emoticon' alt=':P' />

I found this:

Work but don't Ok

It takes assortment parts for selected and viewed Order

not proper for record you want to add to table Production

Zavka,
this schema works only if you go to Details table through the Master table.
Here is the recommended workflow:

1. Proceed to Orders table and pick any Order to view Details
   
2. On Details page click Add new to add new record
   
3. Go back to list of Details
   
4. Go back to Master table
   
5. Pick another order and repeat steps 2-4.
   The whole idea of Master-Details relationship is to pick master table first and proceed to details after that.

Thanks a lot for help
I have only one question about this ->

We'll add a feture in the next version of PHPRunner that simplifies creating dependent dropdowns when category field is not in the same table. Currently you can use a workaround I have suggested.

It is or will be on TODO list?

Sure, I got it on my TO DO list.