Tom, Be sure that Locations and Costs share a common column name, and those common column names contain data tha links the two together, e.g. a Primary Key and Foreign Key.
If that's the case, then pull down the "Table" menu in the form designer, and choose "Add Table." From then forward, every time you work with a database control, you'll have to be careful to pick the appropriate table in the control properties. (If that's not the case, then we'll either have to create a view to give aliases to the linking columns for this form, or we'll have to come up with a way to use variable controls and eeps to manage the secondary table, or a way to use controls and eeps to pop-up another form when you need to work with the Costs data.) Have fun! Bill On 12/3/07, Tom Frederick <[EMAIL PROTECTED]> wrote: > > Is there a simple way to add a second or third table to an existing form > without rebuilding the form from scratch in V8? I know the Form Wizard will > allow Master/Detail forms and the samples have several examples of > multi-table forms. I can see how to build these as a new form, but is > starting over the only option for existing forms. Simple example: the form > "Vacation" uses the table "Locations". I would like to incorporate the table > "Costs" into the "Vacation" form. The help files and the tutorials do a nice > job with Form Wizard, but I can't find info on adding tables after the form > is in use. If starting over is the answer…well so it goes, but a simple > F/Key or an "undocumented feature" would be terrific. > > > > Tom Frederick > > Elm City Center > > 1314 W Walnut > > Jacksonville, IL 62650 > > Off - 217-245-9504 > > Fax - 217-245-2350 > > Email - [EMAIL PROTECTED] > > Web - www.elmcity.org > > >
