Search results

In the entire database, I've got several M:M relationships, so working with junction tables isn't the problem. The problem lies in the fact that I've got a table with all the resources/products, and one table where some of these should figure as Resource and some as Products... e.g. Wheatfarm...

Hi guys & gals, Let's say I've got a table with factories, and a table with products. Several of the factories make several of the products, so M:M. BUT, some of the products of one factory are resources to an other factory, and since I want to show (in a form) what each factory needs and what...

First, thanks for the reply. Second, this is a learning experience. The result is not important (I actually don't need a CD-database), it's how to get there I'm interested in. And third, I've got the 2003 edition, and this analyze thingy doesn't recognize a M2M. To recap, I don't want a...

Hi guys & gals, First off, I'm pretty good with Excel, but a total newbie to Access. I believe in steep learning curves, so to get to grips with Access, I'm trying to understand the logic behind a M2M database. But I simply can't seem to work out what's involved :( . Let's paint the picture : I...