ACCESSS helllllppppppp

[rkhart]

I know this may sound very basic but I have just begun using Access. I
have created 2 tables formed a relationship with the primary key. I
want the tables to have a drop down icon so i can see the information
from the first table on the worksheet and vice versa. If anyone can
help me i would gretaly appreciate it.

 

[Guest]

Well, I understand you just started with Access, but you need to get your
head around some Access concepts. You are thinking in Excel. There are no
worksheets in Access.

The most common problem people coming from Excel have is trying to make
Access work like a spreadsheet. It is not at all like that. It is a
relational database.

Now, the two tables you have. What is the relationship between the tables?
What information is in each?

What you are calling a DropDown is a Combo Box. Combo Boxes are controls on
forms. You use forms to search for, view, add, modify, and delete data in
your tables.

But, before we start with forms, let's get our tables done correctly. There
is nothing more important than a well normalized database. It makes
everything else you do in Access a lot easier.

Send me info on your tables and what you want to do with them, and I will be
happy to help.

 

[Dave Miller]

Dave,

I believe that he was referring to a relationship between the tables
where he could hit the little plus sign and see the corresponding
records from another table. Example; tblPublishers, joined to
tblBooks on PublisherID

Dave Miller

 

[Guest]

Possible, but he used the term "Worksheet"
There are no worksheets in Access.
I hope my post was not taken as an admonishment. My intent is to answer the
question and help the OP get thinking in Access rather than Excel.