E
Excel
Need help creating a databes who can store orders for materials!
In Report should be columns like this:
- ID_order
- Date order
- Company name - link to table Company
- Material - link to a table material
- Quantity
how many tables I must have and what is link beetween them (primary key,
etc)
1. Orders
Id_order (auto number)
Date
Company name
2. Company
Id-company (autonumber)
Company name
Street
Town
Contact
3. Material
Id_material
Material name
Quantity in kilograms
In Report should be columns like this:
- ID_order
- Date order
- Company name - link to table Company
- Material - link to a table material
- Quantity
how many tables I must have and what is link beetween them (primary key,
etc)
1. Orders
Id_order (auto number)
Date
Company name
2. Company
Id-company (autonumber)
Company name
Street
Town
Contact
3. Material
Id_material
Material name
Quantity in kilograms