Hi
I am attempting to setup a database that will allow my organisation to select contractors to invite to tender for work.
The contractors must be selected at random to ensure fairness.
I have a command button - "Generate List" when this is clicked it runs a query which selects five random records from my tblContractors table and appends them to tblLists table. My problem is that if a contractor declines to tender we may wish to choose another 1,2,3 contractor(s). I thought maybe there could be a button "Add Contractor" which would add an additional contractor from tblContractors into tblList each time it is clicked. I can manage this, however I want to make sure that the contractor is not already in tblList before adding them again which could happen with random records!
Any suggestions on how the append query could stop upon finding the contractor already present and then select another one automatically?
I hope this makes sense!
Cheers
Lee
I am attempting to setup a database that will allow my organisation to select contractors to invite to tender for work.
The contractors must be selected at random to ensure fairness.
I have a command button - "Generate List" when this is clicked it runs a query which selects five random records from my tblContractors table and appends them to tblLists table. My problem is that if a contractor declines to tender we may wish to choose another 1,2,3 contractor(s). I thought maybe there could be a button "Add Contractor" which would add an additional contractor from tblContractors into tblList each time it is clicked. I can manage this, however I want to make sure that the contractor is not already in tblList before adding them again which could happen with random records!
Any suggestions on how the append query could stop upon finding the contractor already present and then select another one automatically?
I hope this makes sense!
Cheers
Lee
