Recent content by janlosangeles

Thank you Richard, Fortunatelly, my tables is not complicated. I only have a different product and colors. I do not have to worry about size or style. Thank you

Yes. Payment - I want to show how much paid and when and against which invoice(s)and Terms?

I want to create a database to track my sales and accounts recievables. When I create an invoice, some customers pay me at the time of sale. In this case I mark my invoice as paid. Other customers buy from me and pay me at later time. How do I create my database to track accounts recievables...

I want to create product table. I have many products with many colors. For example: Product COLOR Hat Blue Hat Pink Hat Red Shirt Blue Shirt Red Shirt Pink Pants Black Pants Red 1) How should I create...

To make my question more clear: Each color can have many color. For example, I can have a Hat in blue color, in red color, and in green color. I have a shirt in blue color, and in red color. I can have a pants in purple and shirts in black. I want to make sure not to have a duplicate...

I want to create a product table. I have many products with different colors. For example I have Product X with Red, Blue, and Green colors. I can also have Product Y in Red, Blue, and Green Colors. But I can not have more than one Product X in blue color. How should I create my table? What...

I want to create a database to track my sales. When I create an invoice, some customers pay me at the time of sale. In this case I mark my invoice as paid. Other customers buy from me and pay me at later time. How do I create my database to track accounts recievables? What other tables and...