Anthony Smith
|
| Posted: 05/10/2004, 6:57 AM |
|
Apologies in advance, this is probably a stupid question, but hey I'm a novice.
I want to create a page that will allow me to add a records to several access tables. I'm using the editable grid builder, and when I click on "Build Query" and the Visual Query Builder is lanched, I then right click and select "Add Table", but my tables aren't there - just the select queries I've created in the database.
Out of frustration I built a select query in the database that includes the fields I need, but when I try to add a new record it returns "field not updateable. (Microsoft JET Database Engine)".
Any help most appreciated. 
|
|
|
 |
Dave F
|
| Posted: 05/10/2004, 7:11 AM |
|
Your either have a:
- group query
- a query consisting of two tables related by a "one-to-many" relationship.
Try to rework your query.
|
|
|
|
Anthony Smith
|
| Posted: 05/10/2004, 7:42 AM |
|
Tried re-jigging my query but still have the error. This is my query -
SELECT tblItems.ItemID, tblItems.ItemName, tblCategory.CategoryName, tblSubcategory.SubCategoryName, tblUnits.UnitName, tblItems.UnitPrice, tblItems.MinimumPrice
FROM (tblCategory INNER JOIN tblSubcategory ON tblCategory.CategoryID = tblSubcategory.CategoryID) INNER JOIN (tblUnits INNER JOIN tblItems ON tblUnits.UnitsID = tblItems.UnitsID) ON tblSubcategory.SubcategoryID = tblItems.SubcategoryID;
It falls over trying to update "ItemName"
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/10/2004, 11:52 AM |
|
Can you update that field directly in MS Access, using that query?
As for fields not appearing in CCS, there may be a specific reason for this. You can contact our support for help with this.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Anthony Smith
|
| Posted: 05/10/2004, 1:07 PM |
|
I have got over this problem now thanks, it was totally down to my inexperience with the product. Apologies for any time wasted.
Anthony
|
|
|
|
diligentman
Posts: 7
|
| Posted: 10/13/2004, 11:14 AM |
|
I just hate it when someone fixes a problem like this and doesn't share what he did. It makes threads like this less useful.
Thanks! 
_________________
DiligentMan,
Northern Colorado |
|
|
|
|
