Search results

Thank you gentleman, JZ, good catch – yes, an order can contain many materials, especially with respect to organic spray; so... I will have to itemize each order (invoice being unique identifier) by material. Robert, That’s along the lines of what I was brainstorming. I’m foggy on queries...

Hi JZ, Thank you for your timley reply. Yes, that's accurate. But im not sure about many to many within applications, Im thinking about this... Many orders (and reorders) will occur. An order will yield many applications but an application will originate from only one order (unless I...

Lets say there’s somebody whose an aspiring DBA and that this person wants to be trained using SQL Server and has an interest with business intelligence. This person has used lynda.com to get familiar with the DBMS and wants more practice all around, with app in general an with writing SQL. This...

I need help. Im returning to Access after 10 + years as a very novice user. Financial Business Analyst in Agriculture here in southern/central California. Designing a database to record fertilizer and organic spray use in field. Primary table is "Applications", where such data is recorded...