AnsweredAssumed Answered

Combining tables to view inside of a portal of records.

Question asked by trizko on Jan 4, 2011
Latest reply on Jan 11, 2011 by trizko

Title

Combining tables to view inside of a portal of records.

Post

Legend:

[]=table

>--- = many to one

---< = one to many

Tables:

[PARTS] - tracks part model numbers and types

[PRODUCTS] - tracks product names

[PART_SERIALS] - tracks individually used part serial numbers

[UNITS] - tracks individually sold product serial numbers

[LINE_ITEMS] - tracks quantity and extended price of units

---------------------------------------------------------------------------------------------------------------------------------------

I have 4 tables oriented like so:

[LINE_ITEMS]>---[UNITS]>---[PRODUCTS]---<[PARTS]

and

[UNIT]---<[PART_SERIALS]>---[PARTS]

The problem: My company sells products as a whole, BUT ALSO parts by themselves.

How can I make this work smoothly?

Outcomes