Help creating database and forms.

Hi!
I'm new to using Access and need help. I would like to create a form that
my sales reps can enter their request into. That form would include: Rep Id,
IAC, Pounds, Pt#, 1e#, Ht#. I want to be able to go into this database and
process their request and post it back to them with a Status Field, Submit
Date Field that I would update(but I don't want them to be able to enter into
those fields). This could be another form if it has to be, I just don't want
them to be able edit it.

I also would like to create another form that is probably linked to the form
I post to so they can search for by either the Part # or Heat # to pull up
all records matching their request.

Is this possible or am I just doing some wishful thinking??

You need to create a data structure (tables) first, then some forms for data
entry/display, then reports to summarize your data. For a starting point,
look at the Inventory Control template that ships with Access, and look at
the Northwinds sample database for further ideas.
-Ed

"Anjanette" wrote in message
...
Hi!
I'm new to using Access and need help. I would like to create a form that
my sales reps can enter their request into. That form would include: Rep
Id,
IAC, Pounds, Pt#, 1e#, Ht#. I want to be able to go into this database
and
process their request and post it back to them with a Status Field, Submit
Date Field that I would update(but I don't want them to be able to enter
into
those fields). This could be another form if it has to be, I just don't
want
them to be able edit it.

I also would like to create another form that is probably linked to the
form
I post to so they can search for by either the Part # or Heat # to pull up
all records matching their request.

Is this possible or am I just doing some wishful thinking??

I think you want a backend with the info they put in and give them frontend acces to that BE. You would have db of your own that would link to the same BE but you would have a table ONLY in your db that allows for entering status, etc. You would also have a table in their databases that you would run a Make Table query to add to that table to their db whenever you entered status, etc. Even if they change the data, the next time you enter a status the changed data would be corrected. You could hide that table form them as weel.
Hope this answers your question.
Bob

Originally Posted by Anjanette

Hi!
I'm new to using Access and need help. I would like to create a form that
my sales reps can enter their request into. That form would include: Rep Id,
IAC, Pounds, Pt#, 1e#, Ht#. I want to be able to go into this database and
process their request and post it back to them with a Status Field, Submit
Date Field that I would update(but I don't want them to be able to enter into
those fields). This could be another form if it has to be, I just don't want
them to be able edit it.

I also would like to create another form that is probably linked to the form
I post to so they can search for by either the Part # or Heat # to pull up
all records matching their request.

Is this possible or am I just doing some wishful thinking??