Problem linking subforms, filtering and uploading

[sameerk0286]

Hello there,

these problems that i am facing may be very minor to some cause i'm totally new to access and i'ver been trying to design and build a database for my sister but i do not have much of a clue on what i am doing currently. i have already done up the database but there are a few issues that i've been trying to solve for days now but to no avail.

I would really appreciate it if someone could help me out here a bit.

Ok here are my issues...

1. I've been trying to link the combobox in FormQueryEdit to the sub form in that same form but cant seem to work. I just want the form to display the records that the user has selected above through the combobox so that the user can edit and save the record accordingly.



2. Same issue with the FormLocation too. I want the form to be able to show the location that the user has selected above through the combobox so that the user is able to generate a report based on all the records in that particular location.

3. How do you make the comboboxes which are based on the information from tblDetails to not repeat the locations when the user selects it. I want the user to be able to just pick a location and when the user generates the report, the report will show all the records for that particular location chosen. I have tried the "distint" function but it does not seem to work.

4. I have an import function in the database but it is not working. I am not able to import the excel file(although with the same fields) into the database. It just states that the import has to be saved in a new table instead of tblDetail(table i want the records to be saved).


Attached to this msg is the database file that i am doing currently. PLS PLS PLS, i need help. Thank you so very much.

[ssanfu]

Well, you are having problems mainly because you do not have a normalized structure. For example, you are storing the NAME of the Location (text), instead of the primary key (PK) of the table (a long integer). Here are a few links on normalization:

http://en.wikipedia.org/wiki/Database_normalization

http://www.agiledata.org/essays/dataNormalization.html

http://support.microsoft.com/kb/283878

http://allenbrowne.com/casu-22.html



You used spaces and special characters in your field names - see

http://mvps.org/access/tencommandments.htm


I cleaned up your database as best as I could.... I don't understand what you are trying to do.

And I didn't change the field types for the "Location" field. (See above)