Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Ideas
Message
From
13/03/2000 13:18:09
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00345048
Message ID:
00345050
Views:
20
Kevin,

Set up your Work Item with a primary key, and the History Detail with a primary key and also a foreign key that connects it to the Work Item primary.

Save each History Detail entry as a separate record.

>If I use individual records, how do I put it all together so that all
>the history sessions for that work item look like one log as a whole.
SELECT * from history ;
 WHERE history.fkey = cPrimary
  INTO CURSOR temphist
where cPrimary is the Work Item key. THis will give you a cursor with all the details for a particular Work Item, which you can report on, browse, display in a grid, whatever.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform