HELP

A

accessnewbie

I'm totally new to Access and have to have a db by end of day.

It needs 7 input areas in the form and 6 of them have to have drop down
lists and then one open spot.

I tried creating 6 tables with the drop down lists in the columns and then
creating a form to use that but it said its relationships weren't right or
something.

How do I create it and then what do you set up so that when the form is
submitted all the info goes into the same table.

If you know of a download I could retro-engineer I'd appreciate it also.

THANKS!
 
K

Keith

accessnewbie said:
I'm totally new to Access and have to have a db by end of day.

It needs 7 input areas in the form and 6 of them have to have drop down
lists and then one open spot.

I tried creating 6 tables with the drop down lists in the columns and then
creating a form to use that but it said its relationships weren't right or
something.

How do I create it and then what do you set up so that when the form is
submitted all the info goes into the same table.

If you know of a download I could retro-engineer I'd appreciate it also.

THANKS!
Click to expand...

Have you looked at the Northwind example that ships with Access?

Keith.
www.keithwilby.com
 
C

Chris

Halt, breathe and start again. What is the Db for?
Why do you need the input boxes to be drop down lists?
 
J

John Vinson

I'm totally new to Access and have to have a db by end of day.
Click to expand...

That's a ridiculous demand being put upon you. Learn Access from
scratch and design a database? That's a big job!
It needs 7 input areas in the form and 6 of them have to have drop down
lists and then one open spot.

I tried creating 6 tables with the drop down lists in the columns and then
creating a form to use that but it said its relationships weren't right or
something.

How do I create it and then what do you set up so that when the form is
submitted all the info goes into the same table.

If you know of a download I could retro-engineer I'd appreciate it also.
Click to expand...

A Form IS JUST A WINDOW. You wouldn't start with building a Form any
more than you would start building a house by assembling the
windowframes. The foundation comes first! The foundation of an Access
database is the Tables.

What information do you need to store in this database? Is it a bunch
of records about one particular type of entity (which would be one
table) or is it a number of related tables? What real-life things,
persons or events are you trying to represent? What information do
these drop-down lists ("Combo Boxes" in Access jargon) represent, and
where do their contents come from?

Start with the basics - the tables - and THEN go on to the form.

I'm GUESSING - not knowing anything about your requirements, probably
incorrectly - that you will need one "master" table with seven (or
probably eight, including an autonumber Primary Key) field; six
"lookup tables", small tables used to provide the data for the combo
boxes; and a Form to bring them all together. But without knowing more
that's about all that I can suggest.

Good luck.

John W. Vinson[MVP]
 
Top