Hi,

I am relatively new to Access usage and I am learning as I go along. It would really be of help if I can have some answers to some questions. First I am finishing building a database that was already started and will have information on uniforms, safety jackets and other items. Now this will be accessed on a form with tab sheets. There are several forms that use three tables but the tables are not connected so I have to update each table at a time. I need to find a way to connect the tables together without making any problems when I put information on the forms or the tables. I tried making a query and a form and in each time the information was copied several times. I have tried reading some books but they don't give me what I am looking for, I really need help.

Any input that can be given will really be appreciated,

Thanks,

Ruth

It is hard to help you without knowing your table structure...but I don't think you need three tables. Are you storing uniforms, safety jackets, and other items in seperate tables?

Hi,

Thanks for replying, yes I am storing the information in separate tables since that is the way that they want it. They want to break it by what kind of information it has and referece will be the employee #. The database is going to store all the departments info, but it also has some relationship between some of the tables that I need to link. I am going to see about sending a table but so far I haven't been able to.

Thanks,

Ruth

Well the way you are describing the setup, your structure does not sound normalized and I suggest you read up on it before going any further. Do a search on this site for "normalize", and you will find loads of information about it. Also, if you wanted to post your tables, or DB for review, someone here will definitly give you some feedback.

Hi,

Thanks for the information and for any help. I will need to know how to post the DB so it can be reviewed and I can get my questions resolved.

Thanks,

Ruth

In the FAQs is instructions on attaching files. Here's the link.

As Kristen indicated you need to read up on Normalization. There are several thread here that diuscuss it.

One thing that concerns me is your statement; "I am storing the information in separate tables since that is the way that they want it." Users do NOT dictate table design. That is the province of the developer. Users should never see the actual tables. There may be no reason to use separate tables when all that may be necessary is a field in the table that indicates whether its a uniform or safety jacket or what.

Hi,

Thanks for responding, the thing is that I am just finishing the DB I didn't started myself so the basic of it has already been set up. I am going to try to see about sending the attachment of the DB itself and see about it.

Thanks for the help I am at my end of my rope.

Ruth

The attachment didn't work. Did you Zip it first?

I hate to say this, but if the database is not properly normalized or properly designed then its not worth finisihing. You may need to scrap the design and redo it properly. One of the principles of UA is that we do not promote design that does not follow best practices. If you don't get the design right, then you will be applying band aids to try and get the app to work.

Hi,

I think I found a way to get my DB posted so maybe I can have it looked at and have a few answers to my questions. Any help given is greatly appreciated. This is part 1 of my DB.

Thanks,

Ruth

Ok!

This is the second part of my DB.

Thanks,

Ruth

HI,

Well it seems that I was able to get my DB posted and hopefully that will help in answering my questions. One of the questions I was having was how to link three tables together so when one is updated the others are too. The tables are Employees, Uniform Count In/Out, and Uniform Issues. The information is going to be entered thru forms called Safety Jackets, Uniforms, and Uniforms Count which eventually will be in the Master Window, so when the db is clicked on that is the page that will appear. Even though they are separate forms they do share some of the same tables and not very different people will be using this forms and not necessarily the same ones. So we are trying to make it as simple as possible as we can. Thanks for your time and help.

Ruth

First, I would NOT recommend using lookups on the table level as you have done. Lookups should only be done on the FORM level as combo or lists boxes. For more on that see this article.

Other than that your Employee table is OK, Though I would not have had a separate Supervisor table. Just mark employees as supervisor.

The LevelID table is OK also (though you shouldnb't use spaces in object names).

Considering that Safety Jackets are named items then using a separate table for those is OK. But I would have a table for brand and a table for sizes and select them separately.