Search results

Alright,So combing through the model, which has been extremely helpful, I understand how each of these fields relate and what the overall structure and intent is.I see my past errors on combining duplicate information in past attempts.Some questions still lingering:1. When relating the primary...

Jdraw, Will do. I'd rather understand and get this right on the front end before I get errors and failures at the end.

jdraw, I have literally tried to draw this out a million times and was so close each time. That is definitely closer to what I need that anything i've created! I think that model will suite what I'm looking for, and it is extremely clear. Thank you so much. I'll start crunching it into...

Lightwave, Thanks for the reply and guidance. I appreciate how you broke it down in such a simplistic manner. I am having a bit more success today (see attached screenshots of my table structures). As of now, don't be fooled by the data entries, I hand typed all of it in so you all can see...

Gizmo,Thanks for the advice! I've been perusing practically all of the Forum's. It goes without saying, "you don't know what you don't know". I am actually amazed my first Access product works, now knowing I probably broke about 100 business rules. Hah. I am glad there is a community of...

Ok, So sorting through all the links you provided me I decided start from scratch and put my thoughts on paper, similar to your draft. Attached are my rough versions of how I'm trying to get the database to look, and how I think they are best suited to relate. What problems do you see, I still...

Thank you so much for the link and draft. I'm spending time now sorting through where I may have broken some business rules on this one and simplifying the entries to validate or start from scratch. Much appreciated! I'll be back shortly!

All, Bottom Line Up Front: I hit a home run with a complex Access Database (after 30 days of failures and about 1000 working copies; my first Access Project) and I guess made my self so "valuable" I got tasked to do it again; only BIGGER! So heres where I am struggling to put pieces together...

Hello All. My name is Tom. I've recently delved into the wonders of access and have finally met my match after hitting a homer on my first project and now flailing on my second. Excited to get some guidance to crush it. I live in the U.S. in Virginia, am not overly computer savvy, but pick...