multicolumn Combobox

[SSUTTON]

Hi Everyone: I want to make a combo box with 4 columns. I know how to make the combobox but the four column headings are referring to 4 fields in my table. The four fields are only part of a larger table with about 20 fields. How can I make sure that my data that I enter into the combo box will go into the right fields of my table? I have never used comboboxes before but I think it will help me display the information I am intending to use it for. Thanks.

[June7]

Combobox will save only one data to one field. The other 3 fields can display for info but saving will require code.

Should save only unique ID value from the combobox list.

[SSUTTON]

This is what I am trying to accomplish: I am creating a database to store information about families who are part of a group that I am in. If a family has more than 1 child I want the form to display ALL of the children and their information at the same time and to be stored appropriately in the database separated into fields. How could I do this? Would I use the AddItem parameter in the code screen for every record?Thank you.

[June7]

IMO, family relationship database is one of the most difficult (children often eventually become parents).
Then there are the complications of separated and blended families. How to associate children with parents that are no longer a couple?
http://databases.about.com/od/access...e-Template.htm


What is nature of this group? What exactly are you tracking?

[SSUTTON]

We are just keeping a record of who is involved in a group and we provide food hampers to families on a monthly basis so we need to know who is in the family and when they received help from us and we sometimes give other services when needed. We also need to be able to run Reports.

[June7]

Then possibly you need a table for family ID and a related table that has all family members - parents and children.