HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Halt, breathe and start again. What is the Db for?
Why do you need the input boxes to be drop down lists?
 
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]
 
Back
Top