Good day! Am trying to create 2 fields in a table (Medicine and WithdrawalTime). Medicine would be a lookup from a table ListOfMeds.
ListOFMeds table has 3 fields (PrimaryKey, Drug and Wthrwl). What I want to happen is in my WithdrawalTime field, if I choose DrugA from Medicine, it will automatically show the corresponding Wthwl? Hope that makes sense. Right now am using IF, ElseIf in my form. If I have to add a Drug, I have to add to the EventProcedure.
Thanks!