Lookup table

[AlexBen]

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!

[moke123]

google "cascading comboboxes"

[mike60smart]

Hi

Are you saying that the "Wthrwl" field in the table "ListOfMeds" shows the "WithdrawalTime" for the Medicine selected?

[CJ_London]

Do you mean the last date/time of withdrawal?

[mike60smart]

Hi Ajax

No sure as the OP has not made this very Clear.

It would help if the OP would show example data for both his tables.

[moke123]

I misread your question.

What I think you want is to set the withdrawltime field = to your combobox for ListOfMeds column 2

withdrawltime= cboMedList.column(2)

[CJ_London]

if that is the correct interpretation you could just put in the textbox

=cboMedList.column(2)

no code required

[Micron]

am I the only one who thinks this is about lookup fields in a table, which I would have thought most responders would advise against?

Am trying to create 2 fields in a table (Medicine and WithdrawalTime). Medicine would be a lookup from a table ListOfMeds.

[moke123]

am I the only one who thinks this is about lookup fields in a table, which I would have thought most responders would advise against?

You might be. I don't think anyone of us is sure of the question.

Welcome back, BTW. Hope you had a nice trip.

[orange]

Via Google:
Withdrawal time, as relating to veterinary medicine, is defined as the time required after administration of a drug to a dairy cow needed to assure that drug residues in the marketable milk is below a determined maximum residue limit (MRL).^[1] This term is often used more broadly to describe the time needed after drug administration to any food animal where drug residue may be found in marketed meats, eggs, organs, or other edible products.

Hopefully, OP will provide some details to put post in context.

[AlexBen]

Sorry for the very late reply. been away for a while. The database am creating is not a real database in real sense. All our records are encoded in a website thru a text file (notepad am using). Am just using MS Access so it would be way easier to encode. After I uploaded the text file, i would delete all the records in Access.&nbsp; Anyways, my table, tblTREATMENT has a field DRUGname and DRUGwithdrawalPERIOD among others. Every drug would have its own withdrawal period (days), say DRUG A would have 5 days, DRUG B would be 0 days.&nbsp; In the form, I used a combo box for DRUGname (record source: tblTXT, bound column: 1), i could also do the same for DRUGwithdrawalPERIOD, but both would be showing the Primary Key (autoNumber) in the table.&nbsp; I need tblTREATMENT to show me in the fields DRUGname: Penicillin, DRUGwithdrawalPERIOD: 21 days.<br>The field in tblTREATMENT is the Primary Key, Drug Name, Withdrawal Period and Route of Administration.&nbsp;<br>Hope this clear things up.&nbsp; Thanks in advance!

[mike60smart]

Hi

OK so on your Form where you have a Combobox to select the DrugName from tblTreatments,
also inclue the WithdrawalPeriod in your Selection.

Name the Combobox "cboTreatments"

Then add am Unbound Control and enter the following as its Record Source:-

=[cboTreatments].Column(2)

Name the Unbound Control "txtPeriod"

Now when you select a Treatment using the Combobox the Period will populate automatically.