Search results

Your continued help is valuable, I appreciate your kindness. At times I’ve been confused and wondered if I’d get this. Also, I had concerns about asking too many questions. Late yesterday I wrote down what might work for main form and subforms. I called it a day and knew I’d start fresh...

Yes, I'm excitied! I got the combo box done, and my first form with subfrm is completed. Thank you so much for your help. Now onto tackling this one. On the mainform, subform, subform set up; a couple of questions. Is the 2nd subform a subform of the first subform, or are both subforms a...

Not sure how I missed this, as I reviewed the property sheet to set the rowsource. Perhaps I didn't have the fkPlotID combo box hi-lighted. So, now I have the fkPlotID as a combo box, with the row source set to tblPlots. The combo box drop down now displays the PlotID primary keys 1,2,3...

After updating my table structure as noted above, I created the from based on tblFields, and subform based of tblFieldPlots. Attached is a jpg of the form. Working to populate the fkPlotID box using a combo box. I'm able to create a new combo box PlotID within the form and base the source on...

Thank you for your continued help, it's very much appreciated. Ok, so all tables that have a one-to-many relationship don't necessarily need a sub form. Separate forms for these table will work, since they'll be somewhat stagnant. Also, I'll go ahead and make your recommended changes to the...

Attached is my database with a frmTrucks and subfrmTruck Tare. That gives me the ability to enter Tare Weight for each Truck by ID. And, I have frmTruckLoads and subfrmTruckFieldCrops that allows me to enter TotalWeight of the truck loads. I think I'm making this harder than it needs to be...

Thank you. My tendency was to go to forms next, however, I mistakenly thought queries came after tables as I did that in some tutorials. I'll go forward with forms and subforms. Then to queries to perform calculations. I'll let you know how I do.

Glad all looks well, thanks to your direction. Previously I've done queries, forms, and reports in my first database. I had all types of queries for this current Harvest database, prior to getting proper table structure. I don't know why, but now that I have proper table structure, I'm not...

Thank you, that will be great. Attached is the database table structure and relationships. When doing table joins in the relationships window, I checked "Enforce Referential Integrity" in the Edit Ralationsips dialogue box. In your experience, is it also good to check "Cascade Update" and...

Thank you for the answer and the reason not to use lookup fields at the table level. I've bookmarked that link. I'll do all joins in the relationships window. The relationship regarding the haverst date makes sense. Again, the one to many explanation helps. The join field is not the actual...

Thank you. Now that I have the tables in, I have a question about the foreign keys and table joins. For example, the tblTruckTare has the foreign key fkTruckID. I think perhaps the fkTruckID should be a lookup field, giving me the dropdown box to choose the Truck Number when entereing data into...

My apologies, I don't think my post was relayed clearly. I'm not going to drop the harvest date, so I will use tblHarvesetDate. Before getting clarification from you regarding the planting date not being needed, I thought there needed to be some date value there, and thought of substituting the...

Thank you. I'm getting back to work on the table structure. OK, that makes perfect sense. That clears up my confusion regadring plots. And, since I can drop the planting date, I'll do that. Given that I can drop planting date, there is no need to put harvest date (or any date) in...

Thank you for your continued help. I’m working in between your posts, and I’m making some progress. I figured the tblTruckTare correctly, mine matched yours. Another great question. After checking with the dairy, I’m told that we do not want to average only the 3 most recent tare weights for...

Thanks for your help with the table structure, which will be the foundation for a successful project. You’ve made a good point, once the table structure is set, it will be easier to create queries to do calculations. To answer your questions: For items #1 & #2 So glad you asked, I didn’t...

Wow, thank you for posting. Your detailed insights are very helpful. Since my original post, I’ve created queries to determine needed calculations. However, you’re correct that the table structure does not follow normalization guidelines. You’re also right; there is a relationship between the...

I’m creating my second DB. The customer (dairy farmer) has crop fields harvested for feed. There are a variety of fields harvested, with varying acre size. At harvest time, one field has up to 10 different trucks hauling 6 loads of feed per day. Each load per truck is weighed. All loads per...

You're right, Tare weight does change because of different vehicle confirgurations and it IS averaged for the 3 most recent. Thanks so much. Since, the solution worked, I'll go forward with what I have. I'm also encouraged that I can keep working, learning more. Thanks to great folks like you...

Yes, on all accounts above. Yesterday I was a little overwhelmed trying to redesign. Since my first database, 6 months has passed. I need to be in Access regularly to keep it fresh. In my table re-design for one "Load" per record, rather than Load1, Load2, etc., I studied forum posts...

There is so much data with a variety of calcuations, so we need to go to a database. At first I was concerned about changing the table, but, I can see the need to get this designed properly. The database is for a dairy that has various fields for growing feed. The data is input to determine...