Need to show relevant record when form opens

[rehanemis]

Hello,

I have very simple program with three tables and want to make data input in simple way. (as you see the attached file).

on the main form I want that I can choose company name and then start inputting information in dividends section. It allows but when I hit save button it changes information in dividends section to current selected company (please check your self).

Secondly, I want to add that selected company information into transactions form but same problem when I hit Transaction button a form shows there and change the existing information to new selected company name.

Want to know what is the problem.

Thanks for your consideration.

 

[moke123]

At first glance i would recommend that you eliminate the lookup fields in your tables. google "The evils of lookup fields" They may make your tables look easier to read but they certainly make it harder to code.

You may also want to re-think your table structure. For instance I dont see why you would have a cboCompany table when you should be using your tblCompanyInfo to populate the combobox. Same for the other cbo Tables.
Also some calculated fields fields are probably not necessary as you can probably calculate them ( or concatenate them) on the fly as needed.