Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Calculations
Message
From
23/08/2002 12:03:28
 
 
To
23/08/2002 09:28:40
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00692831
Message ID:
00692988
Views:
26
Glad you have the grid working now. I'd suggest starting a new thread to call in some more talent, better qualified to tackle this aspect. I'm a relative 'view' newbie myself ;-)

>Jim,
>
>I went back and physically set the controlsource of the columns after the recordsource was set on the grid and it works ok now. But now I have a problem with my pview. First, I have never used views so I am new at it. Let me explain my situation. I have a table in which the employees enter time spent on job accounts. I have empno,weekending,job number,day1,day2...day7 in my table. I created a pview with my param as empno and weekending. I set all the fields as updateable and the empno as the key. Each employee can have several job numbers they work on in a given week. This seems to cause a problem when I run my form and update the grid by moving from one job number to the other. I get a warning that key is not unique. Thats really true.The unique key would be the empno,weekending,job number combined. How can I fix this?
Previous
Reply
Map
View

Click here to load this message in the networking platform