Recent content by zhining

  1. Z

    help for creating relationship between two tables

    regarding to the combobox you mentioned above, i know it will show all patients in the tbl_patient, is there any way to do the combox that only shows the patients who have test on current date? say, i have 5 pt in for test, i only want to list thest patients. thanks a lot.
  2. Z

    help for creating relationship between two tables

    thanks for you guys' clear explanation. i got part of what you guys said. let me list the tables i created. tbl_Patient FName LName MRN# tbl_Test Test1 (just example, i did not list the name of test) Test2 Test3 tbl_testsetting stimsite recsite one patient can have many different tests, one...
  3. Z

    help for creating relationship between two tables

    hi, all, i am access beginner, the question i am asking may be simple and silly, but please help me out. i created two tables, but i don't know what kind of relationship i should create. in the first table, i would like to put all different tests (medical tests, such as EMG test, and so on)...
Back
Top Bottom