Access Database- Lookup

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

Guest

I am not sure if this is the correct board for this question. Basically, I
am using a database to send letters regarding violations at a homeowners
association. I guess I will just write out what I would like to beable to
do, and if anyone can tell me if this is possible that would be great :)

1. Beable to put in the owners unit number and have it look that info up
from another table and insert certain information about the owner into fields
in the violation database (i.e. name, address, etc.)

2. Beable to put in a code for the type of violation it is and it pull from
a predetermined list of codes with definitions.

Any ideas?
 
comments inline.

jgavette said:
I am not sure if this is the correct board for this question. Basically, I
am using a database to send letters regarding violations at a homeowners
association. I guess I will just write out what I would like to beable to
do, and if anyone can tell me if this is possible that would be great :)

1. Beable to put in the owners unit number and have it look that info up
from another table and insert certain information about the owner into fields
in the violation database (i.e. name, address, etc.)
Click to expand...

yes, it's possible. however, inserting data from one table into another
table is a duplication of data that violates normalization rules. and,
though you've given no details about your tables/relationships, it's
probably unnecessary. just *link* the owner data with the violation data in
a query, and base your report (letter) on that.
2. Beable to put in a code for the type of violation it is and it pull from
a predetermined list of codes with definitions.
Click to expand...


again, yes, and again, don't duplicate data between tables (except for
foreign key values, of course). if you're not familiary with "normalization
rules", "foreign keys", and "relationships", then suggest you stop work on
your database and read up on data modeling. for more information, see
http://home.att.net/~california.db/tips.html#aTip1.

hth
 
Back
Top