Combo Box question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
 
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 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.
Click to expand...

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?
 
Back
Top