J
jacchops
I am working on a database that someone else designed - and the problem I'm
having involves two tables. The first table is Subject_Info (this is the
"starting point" for entering data) and has a ID field (which is not the
primary key because a subject could be entered in twice but on different
dates). The second table is Followup. The ID field in the Followup table
corresponds to the ID field in the Subject_Info table (therefore a subject
can not have a followup without first being entered in the Subject_Info
table). The person that originally set up the database screwed up, and set
the lookup values incorrectly for the ID field in the Followup table. The ID
field SHOULD be looking up the ID in the Subject_Info table, but instead,
they hand-typed in text options (like "Pizza", "Chicken", etc.). There is
another field in the Followup table that does need the "Pizza", etc. options
- but the designer just messed up and put that in the ID field as well.
SO - when I changed the ID field in Followup to lookup the ID field in
Subject_Info - it all disappeared. I then went an re-entered all the IDs into
the Followup table, and it looks fine - BUT when I export it into excel, the
IDs are only a couple digits... where as the actual IDs are 6-9. The the
exported info looks like it's counting - starting at 1 but skipping some
numbers here and there. What is going on?!!
having involves two tables. The first table is Subject_Info (this is the
"starting point" for entering data) and has a ID field (which is not the
primary key because a subject could be entered in twice but on different
dates). The second table is Followup. The ID field in the Followup table
corresponds to the ID field in the Subject_Info table (therefore a subject
can not have a followup without first being entered in the Subject_Info
table). The person that originally set up the database screwed up, and set
the lookup values incorrectly for the ID field in the Followup table. The ID
field SHOULD be looking up the ID in the Subject_Info table, but instead,
they hand-typed in text options (like "Pizza", "Chicken", etc.). There is
another field in the Followup table that does need the "Pizza", etc. options
- but the designer just messed up and put that in the ID field as well.
SO - when I changed the ID field in Followup to lookup the ID field in
Subject_Info - it all disappeared. I then went an re-entered all the IDs into
the Followup table, and it looks fine - BUT when I export it into excel, the
IDs are only a couple digits... where as the actual IDs are 6-9. The the
exported info looks like it's counting - starting at 1 but skipping some
numbers here and there. What is going on?!!