Need Bill of Materials software (or design) for Access2000.

[Frank Martin]

3+ levels needed using the relational database already in use.
Can someone give me a clue?
Thanks, Frank

 

[Frank Martin]

Thank you. But I have seen these already.

Dear Mr. Martin:

Please note that I don't know anything about Bill of Materials software.
Actually, I don't even know what a Bill of Materials is! However, as a good
librarian, I have an idea where to look! I wonder if these links might help.

http://www.mvps.org/access/modules/mdl0027.htm

http://www.mvps.org/access/queries/qry0023.htm

HTH
Fred Boer

 

[Fred Boer]

Ah, well, it was worth a suggestion. I hope someone more knowledgeable than
me will respond to your question. If you don't get any responses after a
reasonable time, you might want to repost...

Good luck!
Fred

 

[Fred Boer]

Dear Mr. Martin:

Please note that I don't know anything about Bill of Materials software.
Actually, I don't even know what a Bill of Materials is! However, as a good
librarian, I have an idea where to look! I wonder if these links might help.

http://www.mvps.org/access/modules/mdl0027.htm

http://www.mvps.org/access/queries/qry0023.htm

HTH
Fred Boer

 

[Frank Martin]

I am in a state of despair, so I've rented a consultant to come over next
week.
He says he can do a 5-level BOM with the query window and not use any VBA
for the fundamental design.
It will involve self-joined tables, evidently.
We'll see.