Ok, so in going through and continually trying to get my database in normal (enough) form. I keep reevaluating my tables and looking at samples. In my sale table (same as an "order" )
PolicyDateSigned—basically the selling date or transaction date
PolicyTelephoneVerificationNumber(given at the time of sale to confirm the sale. without it, no sale)
PolicyNumber--given from the company after a sale
PolicyEffectiveDate (this is different from the date signed)
But now I am wondering if the Company, Policy and Policy Type are actually "details" of a sale. I don't know what to the make of this. We do not collect any money or make any charges. This is an insurance agency that sales insurance policies for multiple companies. And each policy has a specific type. Such as Prudential is company, Life is Policy, Term is type of Policy. To me that information IS the sale, but in reviewing sample DB's the products are actually in the details table.
I have asked this question before, but always mixed up with a more complicated questions. Would anyone be willing to give this a quick look and let me know if my tables are correct or need changing before I start creating forms and queries that just need to be re-done later? I have a whoooooole bunch of those already. Pretty pretty please? I have attached a screen shot of my relationships or I can type more of the table outs. I think I have them all correct for now with the exception of the sales/sales detail problem. Click to view attachment