Search results

Hi, I have a many to many relationship between tblMain and tblComp, where the junction table is jtblMain_Comp. The real life scenario is one person can have many complications, and each complication can be encountered by many people. I've set up a form with a subform, to enter multiple Comp. I...

Hi all, I'm a non-developer (clinician) that is trying to design a database for capturing delivery of babies. I have a one to many relationship between tblDeliveries and tblBabies, because there can be twins, triplets etc. I want to count the number of Caesarean Sections but as a proportion...

Hi, I'm trying to understand if making a selection in one combo box can filter two further combo boxes at the same time. The scenario is recording the types of labour a patient may undergo. The options are: Spontaneous Induced None (Caesarean before labour) If Spontaneous, there are two...

Hi all, I'm trying to use a cascading combo box to filter the options that can be entered into a second combo box. In frmBabies, a Mode of Delivery is selected from 8 options. 4 of these are "normal" deliveries and 4 are caesarean sections. A second combo box selects the Indication for...

Hi all, I'm trying to split a table up because I now realize it won't be able to do what I need in the future. It wasn't designed properly at the outset, and I'm trying to correct it now, and any suggestions would be gratefully received! This is a database of pregnancies and deliveries. The...