Relationship??

[Deadave]

I need to find a way to autopopulate a filed.

I have 2 tables; LookUp Table (has the codes and code description) and
Working table .

In my Woking table, I also have a field named "Code" and the other
named "Description". I bounded the "Code" field of the Working Table
with the "Code" field of the LookUp table. So, in my Woking Table, I
have a drop-down list with all the codes listed.

Now, what I want to do is when I select a code from the drop-down list
(Code field of Working Table), I want the description of that code to
appear in the "Description" field (Working Table).

How do I do that?

Thanks,

Dave

 

[Douglas J. Steele]

Relationships have nothing to do with autopopulating fields.

Why do you want the description to be stored redundantly? You've got it
where it belongs: in LookUp table. If you want to display it, you can create
a query that joins the two tables together, and use that query wherever you
would otherwise have used your Working table.

 

[Jeff Boyce]

Dave

Are you saying you are doing this directly in the tables? If so,
reconsider...

Access tables store data, Access forms display it.

Trying to make tables work like forms (or like you'd expect a spreadsheet to
act) is a formula for headaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Deadave]

Relationships have nothing to do with autopopulating fields.

Why do you want the description to be stored redundantly? You've got it
where it belongs: in LookUp table. If you want to display it, you can create
a query that joins the two tables together, and use that query wherever you
would otherwise have used your Working table.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)










- Show quoted text -

I'm sorry; I'm not very good at explaining.

My Working Table has many fields and 2 of those fields are named
"Code" and "Description". There are many codes and each has it's own
description. So far, I successfully created a drop-down list under
the Code field that has all the codes (from the LookUp Table). I
don't want to type the whole description of the code every time I
select a code from the drop-down list. I want the code to appear
automatically after I selected the Code. The CODES and DESCRIPTION
are in a table named LookUp.

Example:
I have a new client. I enter his name under the NAME field, his
address under the ADDRESS field, and I select the Code "EASEM" from
the drop-down list of the CODE field. Now, In the Field Description, I
want the description of "EASEM" to show up automatically.

SCREENSHOT:http://users.cjb.net/headbangerstudio/table.jpg

Thanks,

Dave

 

[Douglas J. Steele]

I'm sorry; I'm not very good at explaining.

My Working Table has many fields and 2 of those fields are named
"Code" and "Description". There are many codes and each has it's own
description. So far, I successfully created a drop-down list under
the Code field that has all the codes (from the LookUp Table). I
don't want to type the whole description of the code every time I
select a code from the drop-down list. I want the code to appear
automatically after I selected the Code. The CODES and DESCRIPTION
are in a table named LookUp.

Example:
I have a new client. I enter his name under the NAME field, his
address under the ADDRESS field, and I select the Code "EASEM" from
the drop-down list of the CODE field. Now, In the Field Description, I
want the description of "EASEM" to show up automatically.

That's exactly what I understood you to be saying originally. My answer
still stands. You do NOT want the description to be included redundantly in
your Working Table. A query that joins the two tables together is the
correct way to go.