Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need general grid HELP
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00122733
Message ID:
00122929
Views:
17
>new to vfp 5.0 and having grid trouble. mine is the typical parent/child relationship. customer has many orders. customer_table has a key store_custid (made up of fields store and custid). order_table has a key store_custid but i want to sort the grid rows on store_custid_date.

You can not order the grid based on different index key which is not exactly the key for establishing the link on the the master file. Otherwise, the link losses...

>
linkmaster : customer_table
>child order :
>recordsource ?
>recordsourcetype ?
>relationalexpr ?
>
>i do not have a data environment. do i need to open the customer_table, order_table and establish the relationship in code?

I would advise you to use the DE, it is the replacement of hard coded opening of tables or whatsoever. Use DE to open tables, establish relationship, and boom... no need to use linkmaster, child order, etc.

>
>also, need a column of the grid to be the result of a calcution. the return value of a function. how and where do i set this up?

Grid column accepts expression as well. mytable.qty*mytable.price

>
>desperately seeking help - brenda
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Reply
Map
View

Click here to load this message in the networking platform