Hello everyone,
I'm struggling to understand how to normalize my tables. Please see attached screenshot below.
Problem is my tblCause table has CauseID and Cause fields. However, certain causes might have a sub-cause which I'd like to add or remove to. How do I go about this?
Edit: What I have below makes my form/query not updatable because of tblSubCause table.
I'm struggling to understand how to normalize my tables. Please see attached screenshot below.
Problem is my tblCause table has CauseID and Cause fields. However, certain causes might have a sub-cause which I'd like to add or remove to. How do I go about this?
Edit: What I have below makes my form/query not updatable because of tblSubCause table.