Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
cause my eng. is not so good, so i think i should provide more detail info about my problem:
i hv two tables: "sohead.dbf" and "sodetail.dbf" and both of the table hv the same field "so_no", it is a one-to-many relationship, that one record inside sohead, will find a number of records inside "sodetail" with the common field "so_no". Then inside the DE of the form that contain the grid, i hv add two table, one is "sohead", and the other is "sodetail"
* inside form.init
With Thisform.GRID
.recordsourcetype = 4
.recordsource = "SELECT SODETAIL.SO_NO FROM SODETAIL WHERE SODETAIL.SO_NO = SONO INTO CURSOR RESULT
.REFRESH()
EndWith
i'm sorry that i hvn't provide detail info. , hope u can hlp my problem ~
THX
p.s. sorry i don't understand how to use parameterized view, can u more specify.
thx again, i think i cause u inconvience, sorry......
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement