IGrummett
|
| Posted: 07/01/2003, 12:13 AM |
|
I Have installed the package and connected to an Access database. My initial impressions of the package are very impressive. However as part of my evaluation I have hit a snag. I am using ? tables, Contract (holding details of high level contracts), Schedule (which holds details of the week endings, tax weeks and contract weeks), and the timesheet table that holds values for each employee, hours worked and the total cost of the work). The table employees is used to supply drop down lists. I cant find a way of having the 3 tables referenced in the same page. I want the contract details protected, the schedule scrollable and the timesheet details for the week editable so I can ad multiple rows. On submit all values and totals are calculated. Im I oushing the package too far or do I have to get heavily into the coding side.
|
|
|
 |
Aaron J. Scott
|
| Posted: 07/03/2003, 1:29 PM |
|
You will need to build Queries in MSAccess or do it manually by taking the grid's datasource property to "SQL" and typing in the sql statements as required. It is much easier and less foulable to do the queries in Access. In your project settings click the connections tab click the apropriate connection and click modify. Make sure views are checked, then any stored queries can be accessed much as a table is, the exception being a view cannot be inserted or updated, its just read only. You can however use custom Insert/Update/Delete configurations on the record grids.
|
|
|
|
|
