I
ipower2 via AccessMonster.com
I have a project in Access 2000. I am making a database that will keep
records which can fall into several categories. They are CrimeFree,
Nuisance, Criminal, Forfeiture, or TABC. Each of these categories entail
further questions/fields. I have created 6 tables. Main table, NATABC,
NA, Forfeitures, CrimeFree, Contacts, and TABC. My question is what would
be the best way to set up this database? I tried making it one huge table
but the number of fields create a database that is too huge and I cannot
make forms very well. I have split the tables into 5 but I do not know how
to create the relationships. I had thought a tabbed form would do the job,
but I am not sure. Main and Contact Tables will always be present, but
based on the answers CrimeFree, Nuisance, Forfeiture, TABC, and/or Criminal
may become relevant to the records.
I had created a 6 tab form. Main and contact are always visible. The rest
appear based on the answers to the questions. This works great. On the
contact Tab I have approximately 3 checkboxes called Owner, Manager and
Lien Holder. Based on which or how many of the checkboxes are checked then
the Owner questions, Manager questions, or Lien Holder questions appear.
This seemed to be working right until I progressed to the next record. It
seems that the Contact information for record 1 remained constant no matter
which record I selected. I think that this is because of a relationship
error, but I am not sure. Could someone help me with this?
Thanks in advance.
records which can fall into several categories. They are CrimeFree,
Nuisance, Criminal, Forfeiture, or TABC. Each of these categories entail
further questions/fields. I have created 6 tables. Main table, NATABC,
NA, Forfeitures, CrimeFree, Contacts, and TABC. My question is what would
be the best way to set up this database? I tried making it one huge table
but the number of fields create a database that is too huge and I cannot
make forms very well. I have split the tables into 5 but I do not know how
to create the relationships. I had thought a tabbed form would do the job,
but I am not sure. Main and Contact Tables will always be present, but
based on the answers CrimeFree, Nuisance, Forfeiture, TABC, and/or Criminal
may become relevant to the records.
I had created a 6 tab form. Main and contact are always visible. The rest
appear based on the answers to the questions. This works great. On the
contact Tab I have approximately 3 checkboxes called Owner, Manager and
Lien Holder. Based on which or how many of the checkboxes are checked then
the Owner questions, Manager questions, or Lien Holder questions appear.
This seemed to be working right until I progressed to the next record. It
seems that the Contact information for record 1 remained constant no matter
which record I selected. I think that this is because of a relationship
error, but I am not sure. Could someone help me with this?
Thanks in advance.