Link to home
Start Free TrialLog in
Avatar of Alaska Cowboy
Alaska CowboyFlag for United States of America

asked on

Can't see table design view in Access 2010

I dived into Access 2010 and got stuck in the mud. So I'm trying to start with a clean slate.

I am trying to create tables and I cannot see the Design view, only the Datasheet view, see screen shot.

So I created tables that have foreign keys to other tables, but in the Datasheet view I created the FK fields via Lookup, so that masked the actual foreign key, and I believe this has caused me some undue pretzel twisting in some of my forms and stuff.

So I am just trying to figure out why I can't see the table design view. If I did, I would be able to set up the table in the normal manner, which I am capable of doing (from my experience with Access 2000 and Oracle).

Notice in the screen print the table has the "web'y" icon, is that right ?

User generated image
SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Alaska Cowboy

ASKER

Flyster, I don't see Design - only Datasheet . . .

right click doesn't work either, only option is "Open" which opens data-sheet view.
User generated image
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Jeff,

ok, now I get it. I started with a template from Microsoft, Contacts d.b., and it was very good with some good forms and stuff, but then I kept running into problems like this one.

So this is a related question because I think it's what got me into trouble when I dove head first into this project, but I assume that the "lookup" feature in the datasheet view is NOT the way to go . . . so I am planning on re-designing this by creating the tables normally, with foreign keys . . .
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Jeff,

yes, no web for me . . . I dived headfirst into Access  2010 and got twisted up like a pretzel, and you were probably trying to rescue me on some of my recent posts . . .

So I am just starting from scratch in a normal way, no lookup, no web . . . thanks.
Just to be clear, then you may want to start over with a standard database
Jeff,

yes, I started over and it went slick as a whistle . . . what a quicksand I got into. Thanks.
After a rough start diving headlong into Access 2010, I am now doing very well.