MAJOR Trouble with Design of Database

[Sharon W]

Hello,
I am having quite a day with Access. My problem is as follows...
I have used combo boxes throughout my MAIN table. In each look up table
there are three columns (one has a number, text, then number). I have (or at
least I thought I had) identified for the first column number to be the bound
or stored column. The problem I am having is that when I go to export the
data into excel all of the numbers are either starting at 0 where previously
started at one OR exporting as text.
Also, in some cases even the number being stored in the MAIN table is one
off. For example, if someone selects county Camden which = 4 then 3 is stored
in the table.

PLEASE, PLEASE, HELP!

 

[Jerry Whittle]

If you are talking about a lookup field at table level, you just ran into one
of many reasons to not use them. Below is a great list of reasons to dump
them.

http://www.mvps.org/access/lookupfields.htm

Further check out the second commandment here:

http://www.mvps.org/access/tencommandments.htm

Your best bet is to create relationships between your table in the
Relationships window (hopefully with Referential Integrity enabled) and
create lookups or subforms on your forms.