Hi all, I've been having a recurring issue with using SharePoint Lists as the data source for my database. I'm trying to get it to a stage where everyone in our organisation can use it, and SP lists seems to be a good way to do it, with the back end tables uploaded.
However, I've come across this issue which I'm unsure about. The editing of currently established records is AOK, but creating a new record now doesn't work as an ID Number isn't automatically generated, which means that when I search for the new record on my Homepage form, the new record doesn't show up.
When I look at the table in the front end file, there are two ID fields, one is done by SP, and is autogenerated, but the original is no longer filling in a new number when a new record is creating, and it's this column that is preventing the new records from being recognised.
Any help would be appreciated!
However, I've come across this issue which I'm unsure about. The editing of currently established records is AOK, but creating a new record now doesn't work as an ID Number isn't automatically generated, which means that when I search for the new record on my Homepage form, the new record doesn't show up.
When I look at the table in the front end file, there are two ID fields, one is done by SP, and is autogenerated, but the original is no longer filling in a new number when a new record is creating, and it's this column that is preventing the new records from being recognised.
Any help would be appreciated!