Bill and Charles, Talk about the Duh! moment. Instead of my usual give it a shot and research it later, I went with the research it to death method. Only looked at the "Table" menu choice several times and passed because nothing seemed obvious. Now it is as clear as can be. Thanks
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 ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Downall Sent: Monday, December 03, 2007 2:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Add additional tables to an existing Form. 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
