home
•
products
examples
manual
•
faq
support
forum
•
contact
news
•
login
store
More Examples
:
View Source
: Lookup Values
Free Download
This is a Demo. You can not change anything for security reasons.
Back to Grid
phpLens Settings
Column Settings
Choose
Grid Columns
Detail Columns
Filter/Search Columns
* New Record Columns
* Edit Columns
* Must Fill Columns
- Read Only Columns
- Columns to Sum
- Columns to Average
* Columns to Export
* Sortable Columns
- Graph Columns
- Filter Compulsory Columns
Generate PHP Code
Remove All Settings
?
Select New Record Columns
Hide Cols
>>
<<
Show Cols
Up
Down
PRODUCTID
PRODUCTNAME
SUPPLIERID
CATEGORYID
QUANTITYPERUNIT
UNITPRICE
UNITSINSTOCK
UNITSONORDER
REORDERLEVEL
DISCONTINUED
NOTES
ORDERDATE
Cancel
Notes
Show how lookups work. In this case,
CATEGORYID is a lookup based on
select categoryid,categoryname from categories
.
SUPPLIERID is a lookup using
select supplierid,companyname from suppliers
.
email: contact#phplens.com (change # to @) telephone (malaysia): 60-3-7947 2888 fax (malaysia): 60-3-7947 2800
