In a database that was built for me I have
1. A Registration form that collects standard data from each team registered.
2. In Registration there is a subform that allows me to enter the name and details for each member of the team. Several of the fields are drop down fields so I can choose from standard entries, i.e. "county"
3. The drop down is based on a table/query that has all of the "counties" listed with a numerical designation for each. In the drop down you don't see the auto number, just the name of the county.
So far so good and that works fine.
When I pull up the datasheet view of the subform all of the information, including the drop down information is exactly as it should be.
However, the Tbl that collects this information doesn't show all of the information in the same way. The first half of the "counties" field shows the names, the second half shows the "auto number".
The first half is form information brought over from a previous database. The second half is new information entered. There is also a junction box, but it doesn't seem to directly relate to this particular problem (or perhaps it does).
The problem has to lie somewhere between the subform and the main table. . . but I have exhausted everything I know.
If I can provide further explanation to my ability, please let me know.
Thanks for the help.
eileen
1. A Registration form that collects standard data from each team registered.
2. In Registration there is a subform that allows me to enter the name and details for each member of the team. Several of the fields are drop down fields so I can choose from standard entries, i.e. "county"
3. The drop down is based on a table/query that has all of the "counties" listed with a numerical designation for each. In the drop down you don't see the auto number, just the name of the county.
So far so good and that works fine.
When I pull up the datasheet view of the subform all of the information, including the drop down information is exactly as it should be.
However, the Tbl that collects this information doesn't show all of the information in the same way. The first half of the "counties" field shows the names, the second half shows the "auto number".
The first half is form information brought over from a previous database. The second half is new information entered. There is also a junction box, but it doesn't seem to directly relate to this particular problem (or perhaps it does).
The problem has to lie somewhere between the subform and the main table. . . but I have exhausted everything I know.
If I can provide further explanation to my ability, please let me know.
Thanks for the help.
eileen
