Organizing Tables

[davies107]

Hello All,

I need suggestion on how to organize my Tables, Query, and Forms in order to have a better database. I have been told by one of the members here that I have done a lot of things that is not right in my database.

What I am doing now is how to filter my drop down button. first drop down works perfectly fine, but the second and third is not working. i know theres something wrong but i just couldnt fix it. i know theres cascading combo boxes and the Tables should be organize in creating cascading comboboxes but my data are just imported coming from an Excel. its a weekly report that is live meaning changeable every week. but number of columns are fixed as well as the name per columns. is there any code that i sould place in every combo boxes? or aything i should know and should do?

any help is highly appreciated.

attached is my database....

 

[plog]

Can't open it--Unrecognized format. Try posting an .mdb

 

[GinaWhipp]

Hmm, can you help us out with what Business this relates to and what it is you are trying to do.

 

[davies107]

Can't open it--Unrecognized format. Try posting an .mdb

attached an .mdb file....

 

[davies107]

Hmm, can you help us out with what Business this relates to and what it is you are trying to do.

its a database wherein records of the items are in the database. the records/items that are in the database right now is coming from an Excel, i just imported it there. its a weekly report actually that sooner its a challenge for me to compare week report 1 to week report 2 up to week report 12 and generate reports like how many Hold Status are still Open or Closed.

my concern was the filtering of the items. but just recently, ive done the filtering of the 3 combo boxes. my concern now is the Saving of Record and Adding of Records. for Saving of Records, is there a way that when a user save the record it will automatically be saved? not that i have to refresh the database; i want it to be visible that it change automatically without clicking anything. same goes with Adding of Records, once it is saved or submitted the form will be blank again; ready to be fillied with new item information.

i have to take my challenge one step at a time since im not really good in Access or vba. im still learning.

 

[GinaWhipp]

Hmm, perhaps I didn't ask that right... What are the Items? What are you tracking? What Industry is this? Can't advise you about the Tables unless we know what we are looking at.

 

[davies107]

Hmm, perhaps I didn't ask that right... What are the Items? What are you tracking? What Industry is this? Can't advise you about the Tables unless we know what we are looking at.

these are engineering items. im tracking items from Discipline, Module, and Hold Status. if user will choose Discipline from the drop down button (combo box) it will show all of the items as per Discipline chosen. if the user will chose a certain Module; all of the Module will appear in the ListBox as per MOdule that has been chosen. its filtering of items using the drop down button or the combo boxes.

below the ListBox are the detailed information of a certain item. if the user will click 1 item (after clicking or filtering categories in the combo boxes) the information of that item will appear in the subform.

 

[plog]

Gina's tried twice, let me take a stab:


It's career day in elementary school and we are 10 year olds, explain to us what your business does. You are not allowed to use any database jargon, just plain english. No mentions of forms, or drop down boxes or modules.