lulucheung95
New member
- Local time
- Today, 19:03
- Joined
- Apr 19, 2020
- Messages
- 4
I am creating an input form for medical staff to record the used medical consumables for each operation. For each operation, there will be a unique case no., patient name, operation date, operation name and surgeon, however, multiple items will be used for each operation.
I created a main form that contains text boxes for the staff to input the case no., patient name, operation date etc., and a continuous subform which I expected staff could quickly input the multiple lines of product information (e.g. item code, name, brand and qty). The data should be entered to the master table in which each data line represents a unique item used in operation. (So I expect multiple lines will have same case no., patient name, operation date etc., hope you guys understand how it looks like)
But each time when I try to enter a new line of data, a dialogue box popped out and said I couldn't do this because duplicate values are prohibited, unless I change the properties of the fields. Then I changed the "index" of the fields to "Yes (allow duplicates)" but the problem still exists. What should I do? Or is there another better form design that could do the same thing?
Anything/any comments would help, the nurses are recording the consumables with their hands.......and this could be a big problem given human errors can be very nasty in healthcare settings. Thank you.
I created a main form that contains text boxes for the staff to input the case no., patient name, operation date etc., and a continuous subform which I expected staff could quickly input the multiple lines of product information (e.g. item code, name, brand and qty). The data should be entered to the master table in which each data line represents a unique item used in operation. (So I expect multiple lines will have same case no., patient name, operation date etc., hope you guys understand how it looks like)
But each time when I try to enter a new line of data, a dialogue box popped out and said I couldn't do this because duplicate values are prohibited, unless I change the properties of the fields. Then I changed the "index" of the fields to "Yes (allow duplicates)" but the problem still exists. What should I do? Or is there another better form design that could do the same thing?
Anything/any comments would help, the nurses are recording the consumables with their hands.......and this could be a big problem given human errors can be very nasty in healthcare settings. Thank you.