Search results

Thanks Mark, the item doesn’t change whether it’s from supplier A or B. The manufacturer may be different. To keep things simpler I’ll leave the manufacturer out. And each order will have only one supplier. Sent from my iPhone using Tapatalk

Mark, your post gave me some ideas. I will probably have about over 1000 material items. they will be in categories of board, steel, insulation etc. then there could be sub-categories of 1/2", 6"...as i'm typing this I'm thinking of other subs. This is awesome!!

Thank you Mike, i will keep the tblMaterialCategory and use the cascading combo box.

Thank you plog and Mark. Ampersands have already been removed. I will start the redesign based on your other suggestions. In regards to removin tblMaterialCategory, I would like to be able to sort the materials for each project by category and my material list is huge. Can i still do that...

This still isn't working. pbaldy I followed your instructions and still got the same message "I have to have 10 posts before attaching file or links...tried a dropbox link as well...frustrated.

Thanks pbaldy, I tried to upload the pdf file but there was a msg saying I had to have 10 posts before being able to upload files. Is there another way? Sent from my iPhone using Tapatalk

I have a question about table/relationship design. I've attached what I have after many months of google searches, youtube vids and books. The purpose of the database is to track the material orders for each project but I'm not concern about cost only quantities of each item. At this point I...

Hi all, i'm new to this forum and new to databases as well. Currently I work for a construction company as the purchasing agent/manager. Currently, I am self taught in database design and have numerous questions. I look forward to your answers and thank you.