Vendor Selection!!

[skylitz]

Hi guyz,

Currently, I'm working on vendors database. We take quotation from atleast three vendors before placing our orders. All 3 quotations are saved in their respective field. For e.g.

Vendor 1 Est Amount
Vendor 2 Est Amount


Vendor 3 Est Amount

I have also created approved check box in the form next to each Vendors' estimate.

All I want is that, when I approve any of the vendors than that vendor should get saved in the new field say, Final Vendor, so that I can sum up or compare figures of the approved vendors with purchase order.


Or is there any other way to deal with it in SQL.

My Fields are:

Vendor 1 Name
Vendor 1 Est Amount

Vendor 2 Name
Vendor 2 Est Amount

Vendor 3 Name
Vendor 3 Est Amount

FVendor Name
FVenfor Amount

I'm new to access and my logic of tackling with this problem may be wrong. Please advice.

Thanks in advance!!

[NTC]

while you always may get 3 bid - the better db structure is a different approach.

Vendor table is a passive list of all vendors & their relevant info.
Bid table is where you put in a Bid ID and a Vendor ID, and whatever other info relevant(est amount)...and this table has the yes/no field for 'final'. or awarded or whatever word fits.

then you can query that bid table easily - by bid ID, or vendor ID or Awarded ....

the advantage on this is that if you ever want more than 3 bids there is no obstacle.

[skylitz]

Hi Lightwave,

This seems to have partially resolved my problem. I want to incorporate vendor and bid information to the form, so that as I go along record-to-ecord I should be able to see the bids of all vendors, plus the awarded/chosen vendors for that particular record.

In the second phase, I want to see the list of all the chosen vendors with their respective amount in order to compare it with Purchase Order>Charged to amount for cross-checking and to sum up all the amount that we've spent over the vendors.

I want to stick to three vendors for the sake of simplicity. I've also attached the sample layout of my form for your reference.

Thanks!!