Data shown in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've set up a simple database to keep track of coins in my collection. I have
one main table that stores all of the information collected. I also have
several other tables that contain information that is only used in drop down
boxes and then the answer is stored in the main table. These drop down boxes
are dependant on each other, so the data put in one effects the choices in
the other. each of the side tables have 3 columns, one for the key, one with
the data in it, and one with a number that is synced to data in the other
side table.

My problem is this, when the information is entered into the main form, and
then stored on the main table, the information that goes into the feilds
corresponding to the side tables (the drop down boxes) is only the "key
number" for that row, not the field that contains the actual information.

Help
 
My problem is this, when the information is entered into the main form, and
then stored on the main table, the information that goes into the feilds
corresponding to the side tables (the drop down boxes) is only the "key
number" for that row, not the field that contains the actual information.
Click to expand...

That's not a problem; that's how Access is designed, and how it's supposed to
work.

Tables are intended for data *storage*. As such it's appropriate to store just
a link to your lookup tables. They are NOT designed for data presentation or
editing! You should only open a table datasheet for debugging or design work.

In order to see and work with your data, use a Form based on the table, with
appropriate tools - combo boxes based on your lookup tables, subforms for
related tables, etc. This will let the computer see the key number, and let
you see the text value, and leave you both satisfied.

John W. Vinson [MVP]
 
David

If, on your form, the combobox (drop-down) is displaying the key ID/number,
check the properties of that control. I'm guessing you have the ID field as
the first column in the row source, but your ColumnWidth property sets that
first column at wider than 0.

If the column width of the ID (first) column is 0, Access displays the first
non-0 column, but (as it should) still stores the ID in table on which your
form is based.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Maybe I stated my problem incorrectly, or I did not really say what I need...

What I want to do is create a report from the main table telling me all the
info about that item in the table. When I create the report the area for
MintMark is listed as "1". When you look at the MintMarkTable the id "1"
corresponds to Denver Mint.

On my form when I select Denver Mint from the drop down menu, it places a
"1" in the main table under the field MintMark.

I guess what I need to know is how to convert that "1" back to "Denver Mint"
when I make a report about the main table.
 
David wrote:
It sounds like you're building your report from the table.
Create a query including both of the table and select your
fields accordingly then build your report based on the query.

gls858
Maybe I stated my problem incorrectly, or I did not really say what I need...

What I want to do is create a report from the main table telling me all the
info about that item in the table. When I create the report the area for
MintMark is listed as "1". When you look at the MintMarkTable the id "1"
corresponds to Denver Mint.

On my form when I select Denver Mint from the drop down menu, it places a
"1" in the main table under the field MintMark.

I guess what I need to know is how to convert that "1" back to "Denver Mint"
when I make a report about the main table.
Click to expand...
Create a query with both tables
 
What I want to do is create a report from the main table telling me all the
info about that item in the table. When I create the report the area for
MintMark is listed as "1". When you look at the MintMarkTable the id "1"
corresponds to Denver Mint.

On my form when I select Denver Mint from the drop down menu, it places a
"1" in the main table under the field MintMark.

I guess what I need to know is how to convert that "1" back to "Denver Mint"
when I make a report about the main table.
Click to expand...

Base the report, not directly on your Table, but on a Query joining your table
to all of the lookup tables. Select the text field from the lookup table
rather than the ID field.

John W. Vinson [MVP]
 
Back
Top