Hi there,
I'm trying to create a form from a database, don't have a lot of experience and am somewhat muddling my way through...
It is for a hospital, so we have specific 'Services' with 'Wards' assigned to each. We are trying to capture their orders for items, under a 'Type' and then the 'Item'.
If possible, I would like to be able to choose a Service (ie Orthopaedics) and then have a list of Wards (ie R3, S3 and Q3). Alternatively if they chose Critical Care - Burns, Emerg and ICU would be available as a Ward.
Next I would like to be able to have the Type options - Instrument, Tray, Linen & Other, and then each of the available items be populated.
I currently have tables with these all connected, I'm just trying to figure out if it is possible to create a form in this way? Happy for it to be subforms with a table?
Thank you!