Accessible92866
Registered User.
- Local time
- Yesterday, 21:31
- Joined
- Nov 4, 2008
- Messages
- 11
Hello all. Let's see if I can explain this coherently...
I'm writing a database to track construction projects. Companies respond to an RFQ, with a separate application for each discipline (there are 11 of them, such as General Civil Engineering, Cost Estimating, Architechtural, etc.). Each discipline has several subdisciplines--for example, General Engineering has 12 of those, including Roadway Design, Utility Design, etc.). The complication arises when a company submits an application for a particular discipline (easy; just one value in a combo box), but they want to be considered for several subdisciplines (which would be several values from another box).
This database has to be written in Access 2003, which was long before 2007's multivalue fields. How can I easily let a user enter an application for one discipline and several subdisciplines, all nicely visible on one screen? Cascading combo boxes? One combo box and a multiselection list box (which I've never had any luck with)? Check boxes (which I suspect is not good database design)?
I've been going around and around with this with little success and would appreciate any help anyone can offer. Please note: I can pretty much understand code when I read it and can modify examples, but I am not a programmer and sadly don't have time to become one before this thing is due.
Thanks!
Geekette in SoCal
I'm writing a database to track construction projects. Companies respond to an RFQ, with a separate application for each discipline (there are 11 of them, such as General Civil Engineering, Cost Estimating, Architechtural, etc.). Each discipline has several subdisciplines--for example, General Engineering has 12 of those, including Roadway Design, Utility Design, etc.). The complication arises when a company submits an application for a particular discipline (easy; just one value in a combo box), but they want to be considered for several subdisciplines (which would be several values from another box).
This database has to be written in Access 2003, which was long before 2007's multivalue fields. How can I easily let a user enter an application for one discipline and several subdisciplines, all nicely visible on one screen? Cascading combo boxes? One combo box and a multiselection list box (which I've never had any luck with)? Check boxes (which I suspect is not good database design)?
I've been going around and around with this with little success and would appreciate any help anyone can offer. Please note: I can pretty much understand code when I read it and can modify examples, but I am not a programmer and sadly don't have time to become one before this thing is due.

Thanks!
Geekette in SoCal