How can I make the "+" function have more information in tables?

[nitinrao]

Hello everyone,

I'm trying to make a database that records keys. I've already set up everything to make my tables and relationships. However, my supervisor wants to be able to see more information when clicked on the "+" in the "Key Users" table. For example, she wants to be able to see the key name (instead of the Key ID number) and key type. I've been trying hard to find the solution to this and I hope one of you kind souls can tell me. I've linked the .jpeg depiction, or you can download the actual file through
megaupload:

http://www.megaupload.com/?d=E1JI3OGQ

Nitin

P.S. My supervisor is aware that this can be done easily through queries, but she wants that quick glance when we click on the "+"

 

[vbaInet]

Hello everyone,

I'm trying to make a database that records keys. I've already set up everything to make my tables and relationships. However, my supervisor wants to be able to see more information when clicked on the "+" in the "Key Users" table. For example, she wants to be able to see the key name (instead of the Key ID number) and key type. I've been trying hard to find the solution to this and I hope one of you kind souls can tell me. I've linked the .jpeg depiction, or you can download the actual file through
megaupload:

http://www.megaupload.com/?d=E1JI3OGQ

Nitin

P.S. My supervisor is aware that this can be done easily through queries, but she wants that quick glance when we click on the "+"

i've never actually played with that before. i tend not to show my tables to users. can you not try and convince her that you can do it with tooltip texts instead?

 

[nitinrao]

i've never actually played with that before. i tend not to show my tables to users. can you not try and convince her that you can do it with tooltip texts instead?

It's her preference, and she would really like it...it would taking a lot of convincing....

I've seen this done before. I may have an example of it if anyone wants to see it?

 

[vbaInet]

an example would be grand

 

[Galaxiom]

You are referring to the Subdatasheet of the table. They are useful in when working on the initial design but can slow down the database so are best left out of production versions. A subform does the job so much more powerfully.

Access 2007:
Open the table. Ribbon > Home > Records > More > Subdatasheet
Follow the prompts. You can attach a table or a query and define the fileds.

Other versions I think it is in the Insert menu.

 

[gemma-the-husky]

seriously - users should not see tables directly

you go to a lot of trouble managing carefully, what users can do - and this is completely undermined by users "seeing" or interacting directly with tables.

this "feature" may be appropriate for an experienced access user, who knows how to fix problems etc (and even then I wouldnt bother personally) - but in normal use (ie multi-user - normal users) its best avoided. The thing is, normally you use access to provide management systems for unsophisticated users

duplicate the functionality in a controlled way, with sub forms etc, or some other mechanism


-------------
showing keyname/keynumber in a form would normally be done by using a combo box, or an extra text box