Tables v. Forms

[KatieK]

Hi, somewhat new to the design of databases. Here is what I want to do...

I have a table with 3 fields called tbl_WE: Credit#, CreditName, & CreditReq.
Ex:
Credit#: WEc1
CreditName: H2O Landscape
CreditReq: Reduce water reuse

Credit#: WEc2
CreditName: H2O No Potable Irrigation
CreditReq: Non-pot water irrig

In my form, I use a combo box that once the Credit# is chosen, the CreditName & CreditReq autofil....but when I try and introduce another set of Credit's from another table, it replaces my original data of the WE credits:
Credit#: SSc1
CreditName: Site Selection
CreditReq: No farmland, floodplain

My question is this: If I eventually want 6 forms (one for each Credit type), do I have to have 6 different tables?
How do I tie tables together if the only info that is changing is the Credit#, CreditName, & CreditREq?

Thanks in advance,
Katie

 

[KeithG]

Search the forum for Normalization, this should give some general rules for the table schema of your db.