Hi All
I am trying to create an input form that will be used to populate a main table holding a bunch of info. my current DB structure is to have a main table with some financial data with addtional tables that kind of translate the stuff to more unstandable format (EX 4402-01 = creative design). These relations are all 1 to many and done at the table level. In creating the form i am using the wizard and create combo boxes picking the translation tables and having 2 fields one of them being hidden. I finish the wizard and bind the combo by selecting the coresponding field on the main table as the control and record source.
I thought everything was fine until I tried to scroll through my my main table which the form is orginally based off of 1 by one based. The form can successfully update a field if I try and create one using the relations given but it does not show the correct data all the time in the fields if I were to use the input form as a viewer. The relation breaks or something.
Any ideas what I can do to fix. I would like the ability to move to a record and edit it as well as creating new ones with this form. Making changes works properly but the correctinformation is not always displayed.
One other note the records will jump around and will skip some records if I try to go one by one.
Thanks in advance.
I am trying to create an input form that will be used to populate a main table holding a bunch of info. my current DB structure is to have a main table with some financial data with addtional tables that kind of translate the stuff to more unstandable format (EX 4402-01 = creative design). These relations are all 1 to many and done at the table level. In creating the form i am using the wizard and create combo boxes picking the translation tables and having 2 fields one of them being hidden. I finish the wizard and bind the combo by selecting the coresponding field on the main table as the control and record source.
I thought everything was fine until I tried to scroll through my my main table which the form is orginally based off of 1 by one based. The form can successfully update a field if I try and create one using the relations given but it does not show the correct data all the time in the fields if I were to use the input form as a viewer. The relation breaks or something.
Any ideas what I can do to fix. I would like the ability to move to a record and edit it as well as creating new ones with this form. Making changes works properly but the correctinformation is not always displayed.
One other note the records will jump around and will skip some records if I try to go one by one.
Thanks in advance.
