subform fields

[steve]

The main form is the Project Form. The subform represents the list of
contractor's bidding the project, "bidder's list." I want to be able to
distinguish which contractor is awarded the contract. Should I:

a. create an "Awarded" field in the subform. The user can click the option
button next to the awarded contractor? How would I set it up so that the
user can only choose 1 contractor?

or

b. create a field on the main project form "Awarded contractor." How can I
populate this combobox to list only the contractor's from that project's
bidder's list?

Right now the subform is datasheet view. I'm open to any suggestions.

Thank you, this forum is very helpful!
Steve

 

[Beetle]

I would use option B. It seems to me that who a project was awarded to is
information that is inherently related to the project, not the contractor.
That's just my opinion though, so you may have other reasons for doing it the
other way.

As far as how to limit your list, it's hard to tell you exactly what to do
without knowing more about your database, but whatever method you're using to
create your list of bidders now might be a solution. For example, if you're
using a table (let's say tblProjectBids) to define a many to many
relationship between tblProjects and tblContractors, you might want to
create a query to select contractors from tblProjectBids based on the
ProjectID

HTH