Thank you for the link Ken.

You're right, what I need is very simple with no requirement for the
sub-assemblies as in your example.



"KenSheridan via AccessMonster.com" wrote:

Take a look at the demo at:

http://community.netscape.com/n/pfx/...apps&tid=23133


It's the file attached to the second post in the thread and you'll need to
convert it up to Access 2007 if that's what you are using. It is a true BoM
solution in that it handles assemblies and sub-assemblies of an arbitrary
number of levels. It's not intended to be a fully working template, however,
only a demonstration of how the recursive querying necessary to produce a
bill of materials can be simulated in Access.

I suspect that it might not be what you are looking for, however, as what
you've described sounds a lot simpler than a true BoM, and could be much more
simply achieved with tables Parts, Worksheets and WorksheetDetails, the last
modelling a many-to-many relationship between the first two. Post back for
further assistance if necessary when you've taken a look at the demo.

Ken Sheridan
Stafford, England

Egan wrote:
Thanks for the warnings guys. My requirements really are that simple. If
no-one can suggest a template, how about some pointers? Access or Excell? I'm
reasonably comfortable with basic formulas in Excell and I did some messing
about with Access a few years ago. I'm familliar with one-to-many
relationships and normalisation etc. I just don't have the time do devote to
learning it all again from scratch.

That may not be too difficult a database application to create if your
requirements are as simple as they can be... but if you need to define and
[quoted text clipped - 20 lines]

.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201005/1

.