Question Data Entry question (1 Viewer)

[Toolman]

I am brand spankin new to Access so I appreciate your help (and your understanding). I don't mean to be long winded but I don't know how else to explain this.
Example:
4 tables: Books, Category, Publishers, and Author. Building the Books table it was suggested to use the OrdersID, PublishersID, and AuthorID as Foreign keys. But they should be the ID #, not the name.

My question; with hundreds of authors (or whatever else I'm dealing with) how am I supposed to remember that AuthorID 157 is Tom Clancy? I know you can use a lookup field, but is there a way to see "Tom Clancy" but post 157?

If you nudge me in the right direction I would be grateful.

Thanks,
Don

 

[boblarson]

You use a form with a combo box to select the value. If you add the combo box with the wizard you should be good to go. Make sure to select the ID field and the description (or name) field and the wizard will do the work.

Basically what happens is that the RowSource has a query like:

Select ID, MyName FROM MyTable Order By MyName;

And then the combo box's properties are set like this:

COLUMN COUNT: 2
BOUND COLUMN: 1
COLUMN WIDTH: 0"; 1"

 

[RuralGuy]

I suspect this link might be helpful.

 

[Toolman]

my apologies for taking so long to respond.

Thank you both for your help. I really appreciate you taking the time to respond.

Thanks again,
Don