Looking for approval....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am designing a database to manage product returns. I'm after an
experienced persons opinion regarding set up. Can someone please help and/or
make suggestions?

I have 2 tables - one for contact details and one for products. Primary key
one to one relationship/reference between Contact Reference Number on both.
Also one-to-many relationships on Sub Total and Claim ID, and Claim ID/Claim
ID.

This is already sounding complicated, I can email someone the db if they
really want to help....please....just some advice. I have worked on this now
for about 5 days and don't want to waste any more time if I'm doing the wrong
thing.

TIA
 
You seem to have more than 2 tables --
contact details - products -- Contact Reference Number
Seems like Claim ID would be in a third table and reference to Contact &
Product.
You say "Sub Total" as a related field but I would think it is a calculated
results of some kind such as returned items cost.

To do statistical analysis you need to categorize the claims - wrong size,
wrong count, wrong color, broke, scratched, stained, etc. Use one or more of
these for each item.

Hope this helps.
 
Back
Top