Search results

Thanks! Thank you all for the input on this. I'll try out the idea of putting everything in one table (was thinking on that one earlier) and just adding in some extra fields to it. On question though...using the tblCreationsMaterials would I be able to select more than 1 material from the...

Totally Lost now :( OK I have spent the past couple days going thru the forums looking into junction tables and many-to-many relationships, but I must be real dense on this. I can understand the concept but not how to apply it to my situation. I have 3 tables (Woods, Acrylics, Specials)...

Bob, Thanks so much for the info..I went back and re-looked at it all and darn if that old subform didn't just jump out and hit my upside the head :) Thanks! Doug

Neil, Thanks for the info. I have been doing some reading up on junction tables and many-to-many. I have a long way to go but I wanted to test this idea... am i correct to assume that with what I have the material-1, material-2, etc tables are the junction tables between the 3 main types and...

Howdy all, I am trying to build a db to track all the different projects I do on my web shop www.mutzigcreations.com. One thing I need to do is to be able to track the different materials I make things from. This wouldn't be to bad, but sometimes I use several different materials in one...

Howdy all! I am sorta new to access (I used to use it about 6 years ago, but haven't latly so relearning everything), and I am trying to build a db to track the different projects I make for my webstore (www.mutzigcreations.com. I am trying to make a form that is tabbed so that I can enter in...