A
ABZ123
Hi,
I need some help here ..
I have the following relationsships and the correspoding tables.
Patients -< Orders -< OrderDetails >- Products
v v
| |
Practices --------------< Doctors
tblOrders (OrderID, PatientID)
1. I have created an Order Form and I can now select a Patient from the
Combo Box (PatientID). I have also created extra Text boxes for the
relevant field (Address, Tel etc). How do I populate these text boxes
from the Combo Selection. I understand that I have to code he "after
update" event with something like Me.Text5 = Me.PatientID.Column(4).
However the combo box refers to the Orders table which has OderID
(Automatically generated) and PatientID. I need to use the PatientID
and access the tblPatientDetails to get the data I require. Help, i'm
stuck!!
((
2. In the Northwind DB, I looked at the way the Order form runs. It has
a way of selecting multiple items and adds it to list. The above Order
form should let me select a patient and automatically update the
patient details (above question). I should then be able to add multiple
OrderDetails (multiple items as is done in the Northwind DB). The Oder
details will have access tbleProduct (to get a drop down list of all
the product), tbleDoctors (list of all doctors)
I hope this makes sense to someone...
Many thanks
I need some help here ..
I have the following relationsships and the correspoding tables.
Patients -< Orders -< OrderDetails >- Products
v v
| |
Practices --------------< Doctors
tblOrders (OrderID, PatientID)
1. I have created an Order Form and I can now select a Patient from the
Combo Box (PatientID). I have also created extra Text boxes for the
relevant field (Address, Tel etc). How do I populate these text boxes
from the Combo Selection. I understand that I have to code he "after
update" event with something like Me.Text5 = Me.PatientID.Column(4).
However the combo box refers to the Orders table which has OderID
(Automatically generated) and PatientID. I need to use the PatientID
and access the tblPatientDetails to get the data I require. Help, i'm
stuck!!
((2. In the Northwind DB, I looked at the way the Order form runs. It has
a way of selecting multiple items and adds it to list. The above Order
form should let me select a patient and automatically update the
patient details (above question). I should then be able to add multiple
OrderDetails (multiple items as is done in the Northwind DB). The Oder
details will have access tbleProduct (to get a drop down list of all
the product), tbleDoctors (list of all doctors)
I hope this makes sense to someone...
Many thanks