Search results

That's great! Thanks!

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...

I want to record the date and time of an event (baby's delivery) in this field. In the form's textbox, I set the Format property to dd/mm/yyyy;hh:nn so both Date and Time are captured. If I move on to the next control in the form, the display reverts to only dd/mm/yyyy, only changing to show...

I have formatted [DeliveryDateTime] to be dd/mm/yyyy;hh:nn. When I view this control in a form, and the field in a table, only the Short Date is displayed unless my cursor is actually in the control or field. Can I get it to display the time by default?

Thanks plog! You've been really helpful with suggestions as I work my way through this design! At present, [DeliveryTime] only captures time. You have also made me realise that I should remove [DeliveryDate] from tblDeliveries, and have [DeliveryDateTime] in tblBabies, for the very reason you...

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 Kalleo, I'm trying to achieve the same result as you were but am coming up blank. Would you mind sharing your VBA code? Thanks in advance!

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...

Resurrecting this old thread as I have a very similar requirement. Sample database and screengrab attached. I want to prevent duplicate NRIC in tblMothers. NRIC is the natural primary key, but the surrogate primary key is the MothersPK field, which is an AutoNumber. I changed the field names...

That's Awesome!! Thank you Uncle Gizmo!!

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 Rain, Thanks for your invaluable advice. I understand the difference between hard coding a combo box value list and using a table for the lookup. I agree the table is much easier to make future changes. For fields like Gender, where the only 2 options will ever be M or F, I am happy to hard...

I agree that I have over normalised. For the LabourType field, I planned to have a separate table with 3 options None Spontaneous Induced Instead of a separate table, should I just have a field, and enter data using a combo box in a form where Row Source type is Value List, and I type in the 3...

Isn't the relationship between tblDeliveries and tblLaborMethods many to many? As in, One delivery can have many labor methods; and One labor method can apply to many deliveries. In your example, I took it to mean that DeliveryID was the foreign key in tblLaborMethods, related to the...

Yes that sounds good! Can I confirm that as each DeliveryID can have one or more LaborMethods, I would need to make this a Many to Many relationship via a junction table. I guess I should post on the Forms forum to ask about subforms with drop downs to allow conditional selection (cascading...

I'm sorry that my explanation hasn't been very clear. The table is trying to record the different types of labour a patient may undergo. If I leave the None option alone for a moment, that leaves us with Spontaneous (goes into labour by herself) and Induced (started off). A patient in...

I am wondering if I have gone normalisation crazy! For tblLabType, I have 3 options: None Spontaneous Induced However, under Spontaneous, there are 2 optional suboptions, where multiple selection is allowed. That is to say between 0 and 2 options can be selected. ARM Oxytocin And for Induced...

tblGender: Only M or F! Can I use a Combo Box in an form to allow only those options? tblBreastfeeding: The 3 options are Yes, Delayed and No. I suppose that is more accurately described as Immediate, Delayed and No, but that was the requested nomenclature...

2 pictures posted: 1. One to many relationships 2. Many to many relationships with use of junction tables, all of which are with tblDeliveries. These are to replace multivalued fields in the original single table database. I think there are two tables that could probably be replaced with a...

Wow. Having read several tutorials on normalisation, from one table, to what I thought would be three, has ended up with 24! I'm now dreading the next step: query, form and report redesign! But I'm confident that with the help of this great community that if I stumble, I'll be able to get...