You are my only hope

[Sasha-B]

I have a form that loads in with no information exept an autonumber for PatientID. What I want to do is use either combo/list box to select an item of equipment (from tblEquipment) so that I can enter it as being on loan to the patient.
I have not much knowledge of Access and would really appriciate any help please, as I have had no success solving this problem.

 

[Matthew Snook]

Can you explain your table structure a little better? For example, you probably have a "Patient" table, with:

Patient ID;
Name;
etc.;

and an "Equipment" table, with:

Equipment_ID;
Description;
etc.;

Is this correct? Do you also have a linking table to relate these two or others?

Matt

 

[Sasha-B]

My table structure is:
tblPatient: PatientID,Name,Address,Status
tblLoan: LoanID,LoanStart,LoanEnd,PatientID,EquipmentID
tblEquipment: EquipmentID,Description,Cost,Loan(yes/no)

Is this any help?

 

[Rich]

Please don't post the same question under more than one topic, we've seen this one so many times in the past few weeks already.