Help please

J

Jimenda

Once again I am fairly new to the whole Db thing. I am looking to use Access
to have people input information of which I can do with later what I wish.
How do I set up a screen to allow people to to input to my Db? I would like
to have a user to approach the terminal and by making selections from
dropdowns be able to input to my Db. I have my tables set what I need now is
help on what to use for what job. I need my dropdown to display specific
info from various tables. Once the info is chosen by user I want it to
update a different table with that combination of info.
 
J

James Hahn

What you are referring to is a form. Use the form design wizard to design a
preliminary version of the form. It might be based directly on the table,
but it's more usual to base it on a query that you have constructed that
associates the data from the tables in a suitable set of relationships. Then
modify and improve the form until it does what you want.
 
J

John Vinson

Once again I am fairly new to the whole Db thing. I am looking to use Access
to have people input information of which I can do with later what I wish.
How do I set up a screen to allow people to to input to my Db? I would like
to have a user to approach the terminal and by making selections from
dropdowns be able to input to my Db. I have my tables set what I need now is
help on what to use for what job. I need my dropdown to display specific
info from various tables. Once the info is chosen by user I want it to
update a different table with that combination of info.
Click to expand...

What you're describing is (in Access jargon) a Form with Combo Boxes
(dropdowns) on it. Yes, it's very straightforward to create such a
form.

If you're having specific problems doing so please post an
explanation.

John W. Vinson[MVP]
 
Top