Look up box?

[bionicman]

Ok, bear with me while i try to explain.

I have a form with employee names on it, as well as a little more info. (first name, last name, location, team). each employee has a unique ID in our system for instance their last name, first initial (IE: Tom Harry would be harryt).

Right now that ID has nothing to do with my database, just the above information. what i want to do is create another database that saves everyones information, so all i have to do is type in that persons ID, and the other fields will populate automatically.

Is this possible? did i confuse you? If you could help in any way, i would appreciate it. I am kind of re-learning Access, so i don't remember a lot of it, please describe in detail if you can help.

Thanks,
Bionicman

 

[jeremie_ingram]

Is the initial form within access? Are you wanting to populate a new database with information from a current database? Or are you wanting to populate a new database from some other source?

 

[bionicman]

The best way i can describe is....

Database 1 is where i type all of my information in to (first name, last name, location, team). I want to add the field ID to this database.

Once i enter the ID in to DB1, i want it to populate the other information (first name, last name, location, team). the only way i thought this could happen is if i had that information put into a second DB for it to read from.

Basically instead of typing 4 things for each record i enter, i want to type 1 (the ID) and have it fill in the other blanks for me.

 

[jeremie_ingram]

I think what you are getting at is 1) You have a form for entering data with specific fields you want to auto populate when an individuals name/ID is entered, and 2) You want the data stored into another TABLE so that you can keep this basic infomration seperate. Heres how I see it based off of the above description

tblEmpData
######
EmpID
FName
LName
Location
Team


tblOtherInformation
##############
EmpIP (foriegn key)
field1
field2
field3

By keeping these fields in seperate tables, you can then use the relationships to connect the two (via the field EmpID). This establishes a One-to-Many relationship, one employee can be assigned to many items in the tblOtherInformation . You would only have to enter the data once into the tblEmpData, and could call it up in a form.

I will work on an example this weekend for you, let me know if I am on the right track.

 

[bionicman]

That sounds exactly right, and i already have that part setup. i just don't know how to pull it up in my forms.

Thanks in advance for all the help!

 

[jeremie_ingram]

Take a look at this form. I based it off of my earlier description. What I have done is 1) relate the 2 tbls 2) create a form based off of the tblEmpData 3) created a subform for tblOtherData to be displayed 4) added a combo box to the main form to quickly refrence individuals by first initial/last name.

 

[bionicman]

Looks close enough for me to play with it and change what i would need. how hard would it be to change the combo box to just a regular text box? i know you can type in the combo box also though, so if it is a big problem i can deal with the combo box.

Thanks for all the help!

 

[bionicman]

Ok, after messing with it....

I have a couple more questions. I have it in my form ok, and it works, but not exactly the way i wanted.

All of my data is in one table, so i did not have the other info in a sub form like in your example. what i need it to do is enter the employee info, when i am adding a new record. it looks like the way it is doing it now is pulling the record i associate with the ID. the problem is that i have multiple records for employees, but they are all in one table. (very confusing, i did not setup this DB, and i don't really wanna re-do it.) is there a way i can have it fill in the information without pulling an exact record?

Sorry if i confused you again.

Thanks,