Results 1 to 2 of 2

Thread: Select feilds

  1. #1
    Join Date
    Dec 2002
    Posts
    31

    Exclamation Unanswered: Select feilds

    Dear All,
    considering this DB "Specialities" I want to make a Form based on the [doctors]table, In which when i select a speciality, in the speciality field it automatically selects the sub-speciality for this feild, and is updated automatically too,
    as I have done it yet if i change or update a selection, the other feild is not updated, more over i want it to be exclusively selective i.e i can't select a subspeciality other than those from the list to that speciality e.g One's can't select a subspeciality gastroenterologist for a speciality surgeon
    Attached Files Attached Files

  2. #2
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173

    Re: Select feilds

    Hi,

    I modified your db. Please see attached database. Also, I would recommend that when building databases ... it is always a good idea to have primary keys in all your tables, even if they are only AutoNumbers.

    Hope this helps




    Originally posted by mselima
    Dear All,
    considering this DB "Specialities" I want to make a Form based on the [doctors]table, In which when i select a speciality, in the speciality field it automatically selects the sub-speciality for this feild, and is updated automatically too,
    as I have done it yet if i change or update a selection, the other feild is not updated, more over i want it to be exclusively selective i.e i can't select a subspeciality other than those from the list to that speciality e.g One's can't select a subspeciality gastroenterologist for a speciality surgeon
    Attached Files Attached Files

Posting Permissions

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