Search results

Hi All, I need to create a database that can track different manufacturer’s catalog. In a sense, make my own catalogue of other catalogues. Each manufacturer does things a little different but the parts being tracked are ASME certified so they function the same way. They just have different...

I have generated two queries called "qry_GetWellName_GetAPI" and "qry_GetWellProduction" that extracts all the data I need from a csv to make two tables. My issue is that I can not gather all the production data into a query formatted properly for a make table query that contains production...

If I want to count products sold for each appointment with respect to the normalized date how do you recommend I would alter the query. What I am trying to do is generate all of this in one query for an excel plot. Thank you.

That function looks like just what the doctor ordered. I am closing this thread and if I have issues with function I will post to VBA section. Pivot table looks nice too but reading the VBA code it seems straight forward. Thanks everyone.

I am trying to generate a simple report that can be imported to excel for analysis. Currently the database documents failure causes associated with a repair. I need a "Report" that does not duplicate the failed items in the event there is more than one cause associated with the failure. some...

I see that IsLegacy yes/no will be simple. My question is how do I accomodate values that may become "Not Approved in the future" If I use the IsLegacy for legacy import I think I will still have issues with future changes to terminology disposition. Would you still recommend the IsLegacy for...

I thank both of you again. On a side note I think it would be fun to get this up and running some how so I can select ingredients I want to use and query the database to recommend recipes. I'm not sure how I would do that now but will make that a future goal.

@Group I left discussion to return some bad bagels :)...Bought them yesterday and they were already turning today. @jDraw I got that to work now. I had to pull the linking names from the Recipe_Steps table to the Recipe_Step_Ingredients table @GinaWhipp I have seen that website before. The...

I have see that vid before... It is good stuff. I guess my issue is that the dual relation from the junction table is confusing me. It seems that if there is a many to many relationship with two tables that have a compound primary key between them there needs to be multiple relations made...

I have resolved my table structure issue and it turns out there is a better way!! http://www.access-programmers.co.uk/forums/showthread.php?p=1367961#post1367961 Big thanks to forum member GinaWhipp.. I am now trying to figure out logic on how to programmatically set the component combobox...

Ok that seems too easy HAHA. I still don't understand how you got the referential integrity to work. Do you have to link both of them without referential integrity first? Also, I do not understand this type of relation. I am so used to having a primary key ID and just indexing the fields...

I am trying out the ERD for a recipe database and can not get the relationships I should be defining on this model. I get an error when I try to have referential integrity between the recipeID in the recipe_steps table and the recipe_steps_ingredients table. Recipe ERD...

Works like a charm!:cool: Followup to your last comment Does this mean that I need to have a date associated with the approval...Like an approval date? If so, perhaps I can use that as criteria for the record source of that component combobox. If today date is less than the approved...

Thanks! I will look at this immediately. I don't know why I did not see the email notification for the response. I could have been working on this for days now:banghead::banghead:. Anyway. Thanks again. :)

Yes sunday funday.:D:D I am merrily preparing for a presentation I have tomorrow and trying to keep the database question coming because I know you all have important things to do too. I figure if I ask a question today that will get the ball rolling on a solution within the next few days...

I LOVE THAT WEBSITE. I used it for this project about 6 months ago when I started and also used it for another project. I think for this project the best and most closely related design is "Tracking software problems"...

Also I am curious if a facility type or item became no longer approved terminology how would that impact the cascading? Looking at the data for import I don't see any facility types that would cause this issue but I do see some items that are using Un-approved terminology (They were approved...

Yes the tblName_Components is all the different combinations. Ok so I do not need to store the other values, in that case should I just have those comboboxes unbound and use them to guide the user to the correct ComponentListID? Can I use the same strategy for cascading? Another one of my...

I have made corrections and added some records in the newly attached DB 1 & 5 I have related the tables with more precision now. 2 Now that I have been working on fixing my errors and thinking about this project more, row source data seems to be the root question I am...

I am really struggling with how to deal with this issue on a fundamental level. I started another thread to make sure my table structure is going to accommodate my question on this thread. I have not loaded data into the repair tracking log table because I want to make sure I am on the right...