In any event, you can only update one table with a form at one time. A form is really based on a single table
I did not know this. The weird thing is up until 3 days ago I was able to update 3 tables from the single form (using inner joins), it finally stopped working when I tried to add tables 4 and 5, lol.
is this just for fun, or is it a work task? can you get some professional help with the design?
This is for work and unfortunately we have zero professional help available. It is just me, myself and I at the helm and this ship is sinking fast, lol.
I agree with you gemma, I definitely put the cart ahead of the horse. I was so into the form design and realized too late that I messed up.
BTW in tblCases. CaseID should be your Primary key. I assume it is Autonumber. This would then change all your Foregin keys to numbers..
I forgot to remove the CaseID field. I want the CaseNumber as my pk in the main table.
The pics of the tables in the relationships show all the information needed for my db. I guess I just thought that a form with tabs was the way to go, but I am now rethinking that one as well.
You show only 5 Tables in your relationships pic.
I left out the document table, sorry
Your original design is more like grouping like things together into different Tables rather than separating Repeating Data, which is what Normalisation is all about.
Rainlover, so repeating data as the addresses? like jz pointed out in an earlier post?
I know you guys (most of you) probably do this for a living and it comes very easy to you, but it does not for me. I sometimes struggle to grasp what you are trying to convey to me through these post.