NEED HELP WITH FORMS?????????????????????????????

[Guest]

I would like to create a form that would allow the user to enter the
specializations of members by using 5 combo boxes for 5 specializations. The
thing is that the database is set up as many members to many specializations.

The many to many relation has made me create 3 tables


Member table

MembID pk - currently 200 records
Address etc
UniversityID


Memberspec table

MembID fk - currently 1000 records
SpecID fk
Series eg (1,2,3,4&5) - 1 most favoured spec and 5 least


Spec table

SpecID pk - 20 records spec ID - 0 means no data or no choice
Description of spec eg (Accounting, Information systems etc)

I would like my form to be able to edit specialization details of members
via combo boxes, displaying the text(description).

The user should also be able to choose the specializations when adding a new
record to the members table.

I am new to access so please give advice which is easy to understand and
carry out.

I can send you the file if you woud like to look at it.

Thanks.

 

[Guest]

Rather than use 5 separate combo boxes on your Members form, based on the
members table, use a subform within it linked by the MembID columns. The
source object for this subform should be a form based on the MemberSpec
table. Make this a continuous form with just one control, a combo box bound
to the SpecID column, but showing the specialty Description from the Spec
table (the combo box wizard can set this control up for you if you're not
sure how to hand-craft it).

You should end up with a subform in your Members form in which you can enter
as few or as many specializations per member as you wish simply by adding new
records in the subform, selecting the relevant specialization in each one.