Hi,
I have three tables: (1) Sales and (2) Sale Details (3) Slabs
(1) Sales Fields
- ID (primary key)
- Invoice Number
- Customer ID
- Date
(2) Sale Details Fields
- ID (primary key)
- Sale ID (foreign key to Sales)
- Slab ID (foreign key to Slabs)
- Rt/SqFt (price)
(3)Slabs Fields...