At 06:40 PM 9/10/2005, Bryan Bornstein wrote:
My question is, how do i make the form so that the user can add additional rows so that he can enter in many different BOL #'s, Pro#'s, Consignees, etc. for 1 trailer? When i make more rows in my form, it automatically fills in the information to match what was entered on the initial row.
Bryan, It all depends on the design of your database, i.e., One-To-Many relationship between the "master" table for trailer and as many BOLs, PRos and Consignee rows for the "detail" table. Also the PRIMARY KEY for the trailer number in the master table should be referenced to the similar column name as FOREIGN KEY in the detail table. In your particular scenario, you should be able to achieve your goal by designing a One-To-Many form using the DB Edit Controls for the master table and a "Scrolling Region" control based on the detail table. To understand this scenario, take a look at the following forms in the sample ConComp database: Database: ConComp (C:\RBTI\RBG7\Samples\ConComp) Forms: OneToMany, OneToManyDBGrid, OneToManyScrolling Hope that helps! Very Best R:egards, Razzak.
