[RESOLVED] MS Access 2000, Normalizing Database

[jmhfloor]

I have been dumped on this old database. The tables are not normalized. I am having a problem with the forms. I figured I needed to start from scratch and just import the data. The problem is the forms. The way it is set up now.

There are tables that hold static information. This information is pulled by combo boxes onto the form for user selection. All the information that is selected and inputed goes to 1 massive table. I am wanting to break this table apart so it will be normalized like the other tables that has been created. The problem is when I try to recreate the forms for the people to use it will not let me. The page keeps comming back blank when I run it. I am using a select statement as my control source for the form. I thought I could do this so the information would be put in the multiple tables. instead of the 1. I have the row source as the parent tables that is holding the static onformation.

How can I have one form store input information in multiple tables?

Any help would be appriciated.

Thanks.

[Static]

if u need to bind the controls...

try creating a Query that pulls it all together.. then link the form to that instead of try to use a select statement

[jmhfloor]

I must be doing the query wrong. the form still comes up blank.

Here are my tables

SelCabins >Information pulled from
SelVendors >Information pulled from
SelEmployees >Information pulled from
TblCabins >Cabinname stored here
tblVendors >Vendorname stored here
tblemployees >Employee name stored here

Where should my relationships be. Which fields should I have in the query.

[Static]

... How Should I know?? your tables could have 20 fields in each?
unless.. are u saying u have one field in each of those tables?? if so.. no good.
Normalizing a db is about splitting up data into pieces so u dont have huge tables.
not splitting each field into its own...


anyway...create the query with the fields u need.. in the query, add the tables, add the feilds from each table.. then join the fields that match...
if u are normalizing the db.. you should have some sort of Key field in each table that can be link across all of them.. like an ID field...

keep working on the query until u get it to return what u need. then link the form to that query..

[Static]

?? resolved??

please post what u did to resolve it.. so that others can benefit