Search results

Forgot to attach. It's apparently bed time.

Perfect. Now the key to the rest of the tables is to add them as needed. So add tblAffiliations, tblVendors, tblSupplyRequest, tblMonogramFrames, tblFabrics and tblReferredBy just like you had initially. Gang's all back! The only tricky table is going to be tblEmployees which needs to be...

To accomodate multiple processes you would need another table in between tblStockArtProduction and tblProcesses. I don't know how many tblStockArtProduction have multiple processes, so you may just leave it like you have it. It happens maybe once a month. Most people don't want to pay for...

Your latest structure doesn't accommodate that. With what you have a product can have just 1 process. How would you put that in the current database structure? Yep I had this "fixed" entries "multi-warehouse" and "multi-showroom" which would be clarified in notes. Not ideal I'm sure. In one...

I'm so pumped! The products table is all things related to our current products- what is is, who makes it and where to get it... this may be more appropriately called "Stock". We do a majority of apparel, but also do mugs, bags, phone covers, and all that jazz. The processes are all of our...

For customer contact, I was planning on showing that as a subform as well (on the Customer form). Same issue as Projects and StockArtProduction... got it to show created contact. Couldn't get it to auto populate the new additions. On the projects form, ideally you would click the customer...

I may need further explanation of circular relationships. I'll be happy to get rid of them. Using just the recent screenshot: In EmployeeID in tblProjects and EmployeeIDAssignedTo in tblStockArtProduction. What differeniates these 2 fields? Is this one of those instances you mentioned? >The...

I battled with the StockArtProduction fields. Because purchasing uses that information straight off the workorder (workorder= Projects and StockArtProduction combo view I'm trying to achieve) I think (*hope*) they are in the right spot. With relationships, I may be missing something...

I've deleted all my queries and forms and gone back to my tables on this workflow database. I was being a little bit of a maniac because I hit a wall, but now that I've calmed it down a bit I would like to as all of you lovely experts for your opinion on how to approach this. I am teaching...

Ha thought so ;)

I have too! We're creepers. It started about 2 years ago when I decided "Oh hey yeah I can probably figure that out" and proceeded to beat a template into submission until it would work for us. But of course we've outgrown that so now I'm having to actually beg for help. Glad we've come out of...

So what you are saying is that when I can't get this workflow database to work I can run crying and pleading to you? lol.

I believe I attached a screenshot of relevant table relationships to this post (still new, let me know if didn't work). Thank you for the information you sent. I went back to Normalization and read through ER Diagramming. Different terminology than I learned with, but great information and...

Ha sounds like me! Love it.

Hi all! My husband and I own a custom apparel storefront. We do DTG, Screen-printing, Monogramming, Embroidery, Decals, etc. I am a graphic designer who has taught myself web design and now Access in order to aid our store operations. I'm definitely a newbie, but I have absolutely loved...

Yes! I am familiar with relationships BUT for good measure I will read through the information you supplied. Thanks and I will get back with the requested info. Again, your help is SO appreciated- Thank you.

Of course! I'm assuming just open the relevant tables to show relationships?

Hi all! Thanks in advance for any help with this. I am a complete noob. I've dabled in Access a bit before enough to use a template to get our business a workflow system. But now we've grown... so the need for a more custom workflow system has as well. Anyways, I am building our database...

Great it attached- thanks!

Of course my file says it has security issues and will not upload. I really appreciate your help though, and if I can figure out a way to get you more useful information in order to help me I definitely will. I have a feeling this forum is going to be a huge asset, and I'm thankful I found it.