I am working on a form that has a tab set with connections to multiple tables (one per tab) that is connected to the primary screen by the company no. Each tab has a table connected via the Company_No. I need to attach a screen via a button on the bottom of each tab right under the data sheet view that would be used to edit each row of data in the data sheet. How is the best way to keep the forms synchronized to the data sheet they are connected to. Each data sheet has rows that have the company_No as the first part with -01 through nn for each item. The data sheet is the only means to add another item at the present time. Later I would like to have an add button that would keep track of the last number entered, add a new number attached to the company_no and refresh the data sheet or is that asking too much.
Start Free Trial
