Member Avatar for mrhankey

hi guys,

i am working on a project and i am slightly unsure how to structure this in the database.

basically it is a job card sheet that could have multiple part numbers selected and suppliers along with quantity.

so basically i thought how can i store this in the database?

should i just create 3 columns

Quantity, Parts, Supplier

and insiert the ids of the parts into the parts column of the job and supplier columns.

however i am unsure how the quantity would work?

any help really appreciate as urgently need to push on with this.

cheers

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by hielo
Member Avatar for hielo 
Part
   id autonumber
   name varchar

Supplier
   id autonumber
   name varchar

SupplierPart
   Supplier_id  int
   Part_id      int
   quantity     int
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.