Multi Scheduling and data structures

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi 

I am developing in FoxPro and therefore have FoxPro tables. 

In my applications I have multiple employees (EMPPK). They can set appointments with their customers (CUSTPK).

I want to do the following:

Incorporate the selection of a customer from the customer table 
Display for an employee his appointments 
Admin person to display appointments of multiple employees
Where can I get the default data structure? is it somewhere in the help files? 
Thanks in advance

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
WillieVS Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 02 February 2008 Location: South Africa Status: Offline Points: 8	Post Options Post Reply Quote WillieVS Report Post Thanks(0) Quote Reply Topic: Multi Scheduling and data structures Posted: 03 February 2008 at 7:02pm
	Hi I am developing in FoxPro and therefore have FoxPro tables. In my applications I have multiple employees (EMPPK). They can set appointments with their customers (CUSTPK). I want to do the following: Incorporate the selection of a customer from the customer table Display for an employee his appointments Admin person to display appointments of multiple employees Where can I get the default data structure? is it somewhere in the help files? Thanks in advance
	Willie van Schalkwyk http://www.cyberprop.com

TracyP Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 16 February 2006 Status: Offline Points: 22	Post Options Post Reply Quote TracyP Report Post Thanks(0) Quote Reply Posted: 04 February 2008 at 9:39am
	Hi, I use FoxPro as well. However, the version of the control I started with would not create, or work with DBF's as it does Access tables. The specifications of what needed to be tracked and what this tool provided were vastly different. I connected this tool to an AccessDB to get a general structure and understanding of how I might be able to get it to work with VFP tables via ODBC or OleDB/ADO. In the end, I add data to the control on the fly. There have been many changes to the control since I implemented it. Updating 20K end users that may or may not have administrative privileges does not rank on my list of "Thinks I like to do". There are VB examples in the forum of the new methods. It's a great tool, and saved me many hours. Sometimes I wish I used more of what it has to offer. Tracy