5. Bids Table
Purpose: To collect and evaluate supplier bids.
Columns:
Bid ID (Text, Unique ID, could be a Coda ID)
Equipment (Lookup - from the Equipment table)
Supplier Name (Lookup - from the Suppliers Table)
RFQ ID (Lookup - from the RFQ Table)
Quoted Price (Currency)
Delivery Date (Date)
Currency (Select)
Compliance (Select - "Yes," "No," "Partial" - Could also use a rating system with stars)
Notes (Text)
Equip- 0001
Equip- 0002
Equip- 0003
Equip- 0004
Equip- 0005
Equip- 0006
Equip- 0007