Recent content by skyliner33v

My apologizes Pat. I know this was a common requirement, but it was a bit more difficult because I am using GUIDs (replication ID's) in my db. And there are some different things to get some parts to works. But I was able to figure it out. Attached is the code I ended up using in case...

Thank you Mark! Sorry i didn't respond to this sooner. I had to put this project on the back burner for a while so I could work on another project. But I'm getting back to it now. I've been able to make some pretty good progress on it so far. And I've definitely used the ideas from...

Well crap, I've run into another wall. In my Edit Estimates Form, I can edit the existing data there, but I can't seem to add new data to it. It gives me an error of "Field cannot be updated". Any ideas?

That stinks about your computer. I'm sorry that happened and I hope you didn't lose any important information. I'm still working on the database. I've since decided to abandon the table based form/subform/sub-subform approach and nuked all the forms I was working on. I really didn't have...

Oh my gosh! You sir are my personal hero. Thank you so much!

Not sure. We have another very large database that houses a lot of other bridge information, and they use guids. So I think they wanted to keep the same format with the guids. That part is out of my control.

Hi jdraw. So the business terms are really close to what you describe, with the following exception. -an Estimate can be for 1 or more Category (I'm assuming this) For now (until I'm told otherwise) there will only ever be one category per estimate. So there is no need to assign multiple...

Ah gotcha, yes. I am working on trying to figure out the best way to store the Standard Items that appear within a repair category. @jdraw suggested a junction table that contained only the repair category and associated standard items, but I'm having trouble linking that up with my Estimate...

Hi Mike, I apologize, but I think I know what you mean, but I'm not entirely sure how to implement that idea in practice. I'm not sure how my tables should be linked so that i can do something like you suggest. Do you have any ideas of how the tables can be linked together so that I can...

No bundling of any items. This estimate is mostly to be used for scoping out projects. So upper management just needs a general idea of what items, and their estimated costs at a very high level. Once the project goes to design, new cost estimates are generated that break down each item...

I tried creating the links that you have shown on your v2 diagram, but i get an error stating "No unique index found for the reference field of the primary table". I think this is because the StdItemsPerCategory Table is a junction table and they are only foreign keys to the Repair Category and...

Ahh I see. I think your model makes sense with using a junction table for the standard items and repair categories. I will give that a shot. Thank you so much for your help!

I just checked and all the tables and relationships are there as I had them before removing the extra data. So maybe I need another table in there that only contains the Standard Items that a is supposed to be in a Repair Category? Or can I structure the database like the attached picture? If...

Absolutely! Attached is a copy of the database. I had to take out a lot of the bridges, and standard items in the tables because it made it over the 2mb file size limit, but there's enough in there to get an idea of how everything is structured.

Thank you for the reply. I really do appreciate the help. I thought since I was semi-capable with SQL , that I would be capable at Access, but after working on this for the last 2 weeks, I've realized that I don't know as much as what I thought I did. My database would do basically the...