General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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......
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only