Recurring Table - How to design base on sample data ?

cheer

Registered User.
Local time
Tomorrow, 06:17
Joined
Oct 30, 2009
Messages
222
I am designing tables for a BOM (Base of Manufacturing) system. Example below illustrate the sample data I have

Say I have one ModuleNo : A, under this ModuleNo A, below are its children
Level DwgNo StdQty
1 AAA 2
1 BBB 3
1 CCC 1
1 DDD 1
2 EEE 2
2 FFF 2
2 GGG 1
3 HHH 4
3 III 1
3 JJJ 1
1 KKK 5
1 LLL 1
1 MMM 1

How to create this table base on above info in order to have recurring call for the same table for report generation . Anyone can suggest ?
 
The question is kind of vague but I *think* you mean...

tblClient
cClientID (PK)

tblClientContacts
ccClientContactsID (PK)
ccClientID (FK - relate to tblClients)

...like relating kids to parents. Perhaps you should review...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page...
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials
Sample data models...
http://www.databasedev.co.uk/table-of-contents.html
 

Users who are viewing this thread

Back
Top Bottom