Help creating database and forms.

A

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??
 
E

Ed Robichaud

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
 
B

Bob Miller

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.
 
Top