Print Page | Close Window

Cannot add new item in Categories, UOM, etc

Printed From: Almyta Systems
Category: SBS and AID Software packages
Forum Name: SBS/AID Inventory Control
Forum Discription: Dedicated to inventory management functions in SBS and AID
URL: http://www.almyta.com/forum/forum_posts.asp?TID=16867
Printed Date: 30 Nov 2020 at 9:51pm
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com


Topic: Cannot add new item in Categories, UOM, etc
Posted By: mooniegenie
Subject: Cannot add new item in Categories, UOM, etc
Date Posted: 29 May 2019 at 1:16pm
I'm using SBS version 1.16.151 in Windows 7. I used to be able to add new items to Inventory Categories, Package Types, Units of Measures, etc.

When I click the "Add New" botton, the ID of the new line becomes "#Name?", which is an invalid value, instead of a numeric value. I cannot change the ID and the software won't let me input new data with this invalid ID. Help?





Replies:
Posted By: Debra
Date Posted: 31 May 2019 at 1:53pm
what if you just click on the empty record at the bottom and try to type something?


Posted By: mooniegenie
Date Posted: 31 May 2019 at 3:34pm
If I type something in the bottom row, the ID changes to "0" and it cannot be edited. When I click save, I get this error message:
"The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."



Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 - http://www.webwizforums.com
Copyright ©2001-2011 Web Wiz Ltd. - http://www.webwiz.co.uk