thanks again GingerR
0) Yes each Buyer is related to only one customer. However, there can be numerous buyers for the customer. Buyer is the name of the individual representing the customer.
A) You are correct, there was a company who changed names, (side notte: I build this in Excel last year and it worked fine, just trying to give them some bells and whistles) and half the buyer information was for one customer and then switched. How can I best use CustomerID?
B) Yes, a transaction can be one part, or many parts
C) Yes, transaction can only have one buyer
D) A PartNumber is assigned to each part by the CUSTOMER, not the maker. Stating that, various buyers from within the CUSTOMER can order the parts. The buyer is the POC at the company.
I thought of the simpler names also. That's why I picked Step 1, Step 2, Step 3 and Database. But your suggestion is probably better. I'm open to any suggestions. I really want to learn this stuff.
thanks
Army Scott