I am brand new to this forum and am hoping someone will let me know if I am on the right track with my office365 Sharepoint web access 2010 database. I have created an access web database that has 4 tables currently with lookup fields being used to have relationships for forms and reports.
The lookup field instead of the classic relationship table linking is really strange to me but I have forged ahead. My first issue is that I have imported raw data from an excel spreadsheet into a new table. The problem is that I that the field listed as TANK_1 was imported from excel. That field is just a numerical field instead of the lookup field I created to the left called TANK_ONE. This field performs a lookup from the tank table. Is it possible to take field TANK_1 and have it change to the lookup field with the 201334 value? Otherwise I have to individually select for 500 records each tank which will take forever.
My second question is on the form setup and the way it shows on the sharepoint site. On the very bottom of the page there is arrows and save and create new record etc.. Is it possible to take these out and once the field user hits the save record button, they cannot go back and change the record. I am worried that the field user might start hitting those buttons on the bottom and change old records.
I would like the field user to hit save record and then that record is not editable by them after the fact.
Hopefully this makes sense.