General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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