Search results

Primary table: tbl_mbr Junction table: tblRef_mbrSkills Reference table: tblRef_skills I have a form (frmFilterDesiredSkills) ...with a listbox (listSkills) Column Count: 2 Column Width: 0";2" Bound Column: 1 Multi Select: Extended Row Source: SELECT tblRef_skills.skill_ID...

Worked great! Thanks!

Hi, I have a main form that has a subform with a combo box. If the user wants to enter new data that is not in the combo box list, he must push a button on the main form that will open up another form where he can enter the data and close out the form. I did this using the wizard for the button...

Nevermind. Figured it out.

The problem is that I have a field behind it that is active when I open the form. In my other form, I have 4 fields, but only 2 can be tabbed into. I forgot how to do that for this form. Anyone remember how?

I tried to recreate the successful combo box in the same process as before and now when I open the subform, the highlighted portion in the box is the ID. It also shows the name. The other records show only the name, and when I click somewhere else it displays correctly. It's just that initial...

I deleted the relationship and reconnected it enforcing referential integrity. I don't know what I did, but it works now. Now I need to figure out how to make the combo box expand the reference table if the position is not in the list.

I have a members table and a position table. One member can have only one position, but one position can have many members. How do I show this in the relationships? Is the table setup correct: tbl_mbr (PK) mbr_ID ... position tblRef_position (PK) position I tried to set the relationship...

Thanks! Worked like a charm.

Hi, I have a junction table, a reference table, and the primary table set up: tbl_mbr (PK) mbr_ID first_name last_name ... tblJoin_mbrSkills (PK) mbr_ID (PK) skill_ID years_exp tblRef_skills (PK) skill_ID skill_name skill_description I connected and forced referential integrity...

My interpretation of this is NOT to set up the lookup via the lookup tab for the data type in the table. The way I set it up (and I very well could be wrong - researching via the internet leads to incorrect interpretations of how things should be done) is: I created reference tables (I thought...

Crap, I totally missed that I went from certs to skills. I tried to solve the problem using the skills tables because I had more data there. I'll list the skills table structure tomorrow. I'm going to bed.

Update on what I have done so far: I created my query: SELECT tbl_mbr.mbr_ID, skill_name, skill_description, exp_lvl, years_exp FROM tbl_mbr, tblJoin_mbrSkills, tblRef_skills, tblRef_experience WHERE tbl_mbr.mbr_ID=tblJoin_mbrSkills.mbr_ID And tblRef_skills.skill_ID=tblJoin_mbrSkills.skill_ID...

Okay, I wrote the statement for querying all skills for an individual member (I renamed the tables): SELECT cert_name, cert_date FROM tbl_mbr, tblJoin_mbrCerts, tblRef_certs WHERE tbl_mbr.mbr_ID=tblJoin_mbrCerts.mbr_ID And tblRef_certs.cert_ID=tblJoin_mbrCerts.cert_ID And first_name=[Enter...

Sorry about the confusion. The database is going to track skills, certs, and education. The certs tables were the shortest to type and I figured if I got the answer to this one, I can apply it to the rest. Thanks for the answer jdraw. Tested and works beautifully. I have another similar...

To clear the air, this is not a homework assignment. I was "tasked" by the unit I serve with to create a database that stores members and their skills with the ability to query the database for members with desired skill sets for rapid deployment. I am not a database guy, but since I am a...

I have done nothing more than link them and enforce referential integrity in the relationships window. Do I need to create a query or do anything more to explicitly declare the PKs/FKs? tblMbr: mbr_ID (PK) 1-many with tblMbrCerts first_name etc... tblMbrCerts: join table mbr_ID (FK) cert_ID...

You make a good point about the majors. Would deleting the tblDegreeMajor table and editing the join table to this: tblDegree: join table degree_ID (key) degree_type_ID (key) degree_major ... be a step in the right direction? I made the tblExperience table a lookup table that I joined on a...

I have three tables and I want to formulate a query for a form. tblMbr: mbr_ID (key) 1-many with tblMbrCerts first_name etc... tblMbrCerts: join table mbr_ID (key) cert_ID (key) cert_date tblCerts: cert_ID (key) 1-many with tblMbrCerts cert_name I want to: -Display all the skills for the...

Hi, I have been tasked with designing a member skills/certifications/education database for my unit with the ability to filter desired skills for rapid deployment. I am not a database guy, so I have been using the internet for research on database concepts. Cross section of tables created so...