Just starting with forms

[laythss]

Background:
I have the foloowing tables
tblClient:
ClientID (PK)
ClientName
other client details

tblMachine:
MachineID (pk)
SerialNumber
ClientID (fk to tblClient)
other machine details

tblProduct
ProductID (PK)
ProductName

tblReadout:
year_date
month_date(pk fld1)
day_date(pk fld2)
ProductID(fk to tblProduct)
MachineID(fk to tblMachine)
ReadoutAmount

Question:
I would like to build some kind of a form where the user will be able to enter data for readouts (ProductID, MachineID, readoutAmount, year_date, month_date, day_date), but I would like them to only be able to do that, I mean I do not want them to be able to modify any of the other data in the table or even see it, so only adding a record that is it.
Also I would like them to be able to enter the ProductName instead of ProductID , how do I go around that ?

 

[statsman]

The Access built in security allows you to designate the level of access each user can have.
You have Admin level users - access to everything - thats you
You can also set the permissions for other users. In this case you would only want these users to have data entry access.

The easiest way to enter the Product Name and Number is through a combo or list box on your data entry form.

WARNING: read up on the Access Security features if you haven't used them before. I've been doing it for years and I still screw it up from time to time. I always make a copy of the database and test out the security on that first.