Search results

  1. C

    Filtering problem with listbox

    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...
  2. C

    Can a combo box requery itself?

    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...
  3. C

    Relationships?

    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...
  4. C

    Combo box showing ID vs. Name

    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...
  5. C

    Join table query

    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...
  6. C

    Join tables?

    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...
Back
Top Bottom