I like that idea. As a matter of fact, I vaguely thought about such a column, but it seemed more time-consuming to do that (although a good investment for long-term). I also was afraid there might be concurrency issues without exclusive access to that table during the day. (this is a teeny...
I figured out most of it! I did create a separate table of the desired client_ids (only a dozen so far, just for prototype). And I managed to create a query that gets the address info just for those client_ids.
Yea!
I'm probably all set now. I assume the rest of the steps will fall out...
I have an excel sheet with a subset of Client_IDs and ClientNames. THese are the subset customers getting Christmas cards. I have a typical database table with client info including the address info I need.
I need to ultimately create labels in Word. (Does Avery wizard install in Access or...
I really can't say. I've never used either. Just looking at my options.
I did a small very preliminary prototype in Infopath and it went ok with very minimal reading/learning. I liked that. I have to do some more reading first though to get a better handle on it.
Will do. thanks. I was thinking of maybe using Infopath for a front end. They probably offer something similar. I have to do some reading up. (Haven't even started and I am planning for the migration :))
They don't work like that. new cultivars are constantly being introduced and are...
good point. (and good pun!) argggghhhh that would be a lot of single entries. Design-wise its always best to plant in multiples and groups of the same plant. Maybe I'll just forget about deaths. Other than the fact that "plantings" may grow in qty or shrink in qty but will not...
rereading my post and maybe its not so bad after all... If a plant dies and I replace the same plant in the same location, that would be a valid so-called "duplicate" planting. So I guess status is part of the combination that dictates uniqueness.
Is there a mechanism where I can check...
Newbie here... I think I've got the guts of my table designs okay, but there's a couple of nagging issues. Here's my "virtual" pen and paper exercise. The relationship chart and other Access views just don't cut for me. I had to create excel-style table views to see the data in action all in...
well I thought I understood my data well, but I knew you were right that it makes sense to work with the Form right off the bat. I decided to play around with InfoPath instead of Access for forms creation. I suspect that was much easier than Access Forms. Working at the Form level does put a...
so there's a bit of a catch-22? you have to create a form first before seeing the table. Or, is the form creation a simultaneous activity with table design? I guess its all in the planning.
My lookups were from a stand-alone table that had no relationships (so far). Was that a clue that...
Amazing... first day first mistake...and I felt like I had done something very cool. I guess I better stop playing around and RTM! (and these forums)
I suspect that part of the reason I went in that direction is that designing the tables comes before designing the input forms. I wanted the...
Please bear with me if my questions are juvenile. I am very very new at this (day 1) and am barely following along. I'm guessing at some of your terminology even!
Is this what you are referring to? Is this good or bad?
Thanks on the normalization pointer. Yes, I think that is the crux of my question. I didn't quite follow all the subtleties of the conversation, but that is the essence of my query. (no pun intended!)
I think I need to stop and think hard about my data and my Use cases and my one-to-many...
this conversation prompted me to get back into my plant db design. I am an experienced software person, but a novice in DBs so I ask your help in steering me in the right direction.
I've attached a prelim list of my proposed tables and columns. I haven't addressed foreign keys yet but it...