Multiple Select

Results 1 to 3 of 3

Thread: Multiple Select

  1. #1
    MCG Guest

    Default Multiple Select

    Hi There<BR><BR>I am busy developing a staff directory for my company. The problem comes in here. One person can work at multiple branches. I know how to do the multiple clause and I know that you have to store the value in the database as a text field. The problem comes in when I need to edit the people&#039s records - how do you get the drop down box to have those values that the user chose for a particular person ? How does one do searches on the people if they work in more than one branch(branch being stored as a text value in an Access database.)<BR><BR>Thanks<BR><BR>MCG

  2. #2
    ? Guest

    Default RE: Multiple Select

    hhmmmm... Is all of this information stored in the same table? I understand what you are trying to do, but I don&#039t have enough info to suggest a solution... can you describe your database structure and application flow?

  3. #3
    MCG Guest

    Default RE: Multiple Select

    Hi There<BR><BR>One person can work in many branches. One county has many branches and a region has many counties. Does this make sense ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts