Lookup/query issues

[ellie]

Hello

I am relatively new to creating databases. I can create the table,
understand (??) PK and FK in theory. Here's my issue:

I have a main table: [all_document_info] with fields

[PK]

[reference_number]

[last_ref_used]

[from_short]

[from_long]

I have a second table [dept_refs_name] that contains the data needed in the
above fields:

[PKrefnumber]

[dept_acronym] relates to the from_short field

[full_dept_name1] relates to the from_long field

[ref_number] that relates to the reference_number field above.

This is where my limited knowledge runs out. from_short is a drop down and
I want the corresponding LAST data for that field input into from_long and
last_ref_used. So the table will be sorted by PK. It is a one to many
relationship (I think) or "if
[all_document_info.from_short]=[dept_refs_name.dept_acronym] then
[all_document_info.from_long]=[dept_refs_name.full_dept_name1] and
[all_document_info.last_ref_used]=[dept_refs_name.referene_number]

Can someone explain what I do next? I am truly stuck. Thanks Ellie

 

[Gina Whipp]

Ells,

Before proceeding, I belive you need to look at your tables...

[all_document_info] table
[PK]
[reference_number]
[last_ref_used]
[from_short]
[from_long]

[dept_refs_name] table
[PKrefnumber]
[dept_acronym] relates to the from_short field
[full_dept_name1] relates to the from_long field
[ref_number] that relates to the reference_number field above.


How is your form set up? And what are you trying to do? These tables are
almost identical and therefore do not follow normal databse design, that is,
storing the same information in two place. Perhpas if you explain more, it
will help. Remeber, we can't see what you are doing.

Also, you might want to ready up on relational design...

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm