Combo Box question

[Neil Cash]

I have a subform that was created from two tables, and a combo box in the subform that stores the data into one field on the first table. I need it to also store the same data into the corresponding field on the other table. Is this possible, if so how? If not, what's the best way to do this? Thanks

 

[Averil Pretty]

Why would you need to store the same data in two tables?
The point of Access being a relational database is so that
you eliminate the need for storing redundant data...

How have you set up the tables and what (if any)
relationships have you created?

Regards,
Averil

-----Original Message-----
I have a subform that was created from two tables, and a

combo box in the subform that stores the data into one
field on the first table. I need it to also store the
same data into the corresponding field on the other
table. Is this possible, if so how? If not, what's the
best way to do this? Thanks

 

[Neil Cash]

I have two tables because they all contain the same type of information and there were too many fields to fit in one table. So I went ahead and made the two with a 1 to 1 relationship.

 

[John Vinson]

I have two tables because they all contain the same type of information and there were too many fields to fit in one table. So I went ahead and made the two with a 1 to 1 relationship.

I *very* strongly suspect that your table design could be improved.
I've never needed more than 60 fields in a table; if you have over
255, it's almost certain that you have one or more one-to-many
relationships embedded within each record. What are some typical
fieldnames? What type of data are you storing?