Get value for other page

To me it looks like you have bad database design and you need to add normalization - try this:
Table: Customers

fields:

id

name
pay table

id

name

seller

provider

product

pay date

value

portion
Then link tables as master/detail on the name field. Also, I advise making seller and product tables and looking up these values too.
As for pulling info. automatically (if you update your tables like advised, you won't need to do this):
global $dal;

$rs = $dal->client->Query("name='".$values["name"]."'","");

$data = db_fetch_array($rs);

$values["product"] = $data["product"];
Hope this helps,

Mandy

Mandy,
you need to set up these fields (name, seller, provider, product) as dependent dropdowns.

To do it proceed to the Edit as settings dialog on the Visual Editor tab, switch to the Lookup wizard tab and check This dropdown is dependent on option.

Check video manual "How to setup dependent dropdown boxes on Edit/Add pages" here:

http://xlinesoft.com/phprunner/php-database.htm

Tanks Ann!
sorry do not think I explained right.
an employee will enroll the customer.
then another official will release the portions receivable related to this customer
in a system to a reseller of products
currently is being registered in the customer table Clinet
then the screen receipt or payment, this means pulling lookup
ie I have to pull data repeated!
and then have to make a report with all information
I like to make a report taking data from another table on the screen I could pay only enter the customer ID maturity value and number of the parcel.
but must report the name of customer value portion seller sold many items.

Tanks Mandy.
sorry do not think I explained right.
an employee will enroll the customer.
then another official will release the portions receivable related to this customer
in a system to a reseller of products
currently is being registered in the customer table Clinet
then the screen receipt or payment, this means pulling lookup
ie I have to pull data repeated!
and then have to make a report with all information
I like to make a report taking data from another table on the screen I could pay only enter the customer ID maturity value and number of the parcel.
but must report the name of customer value portion seller sold many items.

Leonardo,
it's difficult to tell you what's happening without seeing actual files. Please publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error (maybe screenshot or two). 'Demo Account' button can be found on the last screen in the program.

I created the account and posted the code

Tanks

http://demo.asprunner.net/net_informatica_hotmail_com/openstoq/menu.php

the fields in yellow! I go with the data in the customer base
I see when entering accounts payable I have to repeat the same data.

I'd like to screen accounts payable, be possible to enter the customer id and come the data registered in the customer master, and was also on the screen as possible to enter some information manually.
relatively simple and do not want to repeat in the register of accounts payable that stuff already typed in the customer master
Thanks sorry for my english

Leonardo,
please send this link to the support forum at http://support.xlinesoft.com sending along with instructions on reproducing this error.