i have two tables with the same data but:
i this is i want
2nd table
itemquantity
product3
1st table
itemquantity
product1
product1
product1
i want that the quantity of a product in the 1st table is sum up to the 2nd table..
should i use locate and add the qty of the same product?..
i am new in creating new properties or methods,
i m done creating method but i cant find the method i created in my property window to code it.
please help..
SELECT item_table
LOCATE FOR status = "For Disposal"
IF FOUND()
thisform.pgfinventory.page1.grdItem_table.BackColor=rgb(159,255,230)
ELSE
endif
i want to change the backcolor of a record with a value of "For Disposal" in the status field
but it just change the back color of all the record
is...
i have table name issue
fields
id name item aqdate number price
sample records
1 bryan laptop 10/10/14 ARE#14123BY 10000
2 simon desktop 10/10/14 ICS#14321SY 10000
1 bryan van 10/10/14 ICS#14123BY 5000
want:
when i filter name bryan or number ARE#14123BY
filter number or the name and determine...
select item_tbl
replace pic with thisform.image.picture
but it replaces the picture of the first record
and nothing happens to the current record i want to edit.
actually, that form contains table and i can see where the pointer points into the record.
i think goto top is something to do with...
select item_tbl
replace pic with thisform.image.picture
but it replaces the picture of the first record
and nothing happens to the current record i want to edit.
please help and thx in advance
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.