Search results

Thanks for such a fast reply Bob! Let me see if I can clarify. When you say subform CONTAINER are you referring to the "Name" as found on the Other tab in the properties window? If so, then yes, it is named subfrm_dates.

I have two subforms that are sourced from the same query. One is in continuous form view and is used to select values, the second is in datasheet view and shows all the values that have been selected (multiple rows here). My goal is that the user will use the first form to make selections and...

Did it again...forgot to attach database: Here it is.

Thanks to all who have provided help on other threads. I have made some progress but I am still struggling with the last couple of relationships here. I am tracking projects and have normalized this data into the following tables: tbl_customers (contains customer specific information) Is...

Thanks for all the feedback guys. I could tell something was wrong here. Perhaps it would be helpful if I describe what it is I'm tracking a little more clearly. These are projects...more specifically commercial install projects. They have various elements to track: Internal contacts...

Would someone mind looking at my database and commenting? I am curious as to if I am headed in the right direction. I am storing the WO field in all the tables to use as a FK in all the tables and as the PK in the WO table...am I storing the Workorder # too many times? I know redundant data...

Dang...try that attachment again

Ok guys. I want to thank you for the feedback here. I went back and re-examined how I was arranging my tables. I had an epiphany and moved multiple date columns into one lookup column. I applied similar logic to all tables in an attempt to make them "narrow and deep". Now comes the tough...

Ha...I realize I'm posting to myself for the most part, but I wanted to add that I might not have a problem here after all. Here is my thinking: Initially my thought was every record created on the main table must generate a record on the child tables at the point of creation. This is really...

I am attempting something similar due to having to deal with mutiple tables with a one-to-one relationship with a main table. I have added the subforms to the main form for each table and established the parent-to-child relationships for each table. Each child table has an autonumber PK...

Ok, well pressing onward! I have created a form from the main table and subforms for all the other tables. I then added each subform to the main form...establishing the parent child links between each form using the PK of the main table and the FK found on each of the other tables. Now...

I have been asked to redesign a database that tracks a huge number of data points. These are projects and the original table had over 100 fields. I have managed to separate them to related tables in an attempt at normalization. They are: tbl_workorders (main project info) tbl_services...

Take a look at this! The DB is still in development. My question is in regard to the second tab on the main form called, "View Open Projects". I have a subform in there housing a query that I am trying to filter based on combo boxes above. Thanks for any help you can provide!

Thanks for the quick reply ajetrumpet! Unfortunately I do not believe your answer to the first problem will work. The reason is that the query has too many fields that need to be driven off the combo box. For example, my query has 34 fields but I can only select 20 columns maximum when...

I've searched through many posts here and read many off forum as well. The more I read, the more I am getting confused as to which method would work best. Setup: I have a table for work orders called tbl_workorders. This table has a many to one relationship to the table of customers. The...

Thank you for the replies boblarson, pbaldy, and Joebax. To answer your questions: I tried your code with the additional syntax reference to the main form (Forms!frmTechMaintenance.frmEmployees.Form.Requery) but it failed to update my subform. Yes pbaldy, the subform is based off a query...

This is so simple but I can't seem to make it work. I've poured through about 30 posts and tried all kinds of AfterUpdate event strings to no avail. Help! Here is the simple setup. I have one table that lists employees and their corresponding teamleader. A grouped query provides the...

shaz123, Just out of curiosity, is this query formed by joining two or more tables together? Improper joins can often lead to unwanted duplicate records depending on how the join is made. There are a number of ways to eliminate duplicates. The most important being ensuring proper joins...

red2002yzfr1, Just for my clarification here. You are currently storing multiple name values in one field? These are then separated by commas or some other punctuation? In essence this is one big text string with multiple values?

Jon K, Ugh...that's so obvious now. Sometimes you can't see the trees for the forest.:rolleyes: Thanks!