I am adding several new tables to a database that is up every day running. Now I thought about dupping information during the transition but ... So my question to the members here is.
You add a table add new column (name also) you have forms, reports, eeps etc... Is there an easy way to find all the places without running some form or report and getting the error message that column does not exist? All because I failed to update that form and insert new table/column and reports. Heck, some of these we use but once in a blue moon but then it fails. Example Client Table has clientid,fname,l,name,car Now we create a new table that is Vehicle it has Car_Id,Make,Model but my report or form had only the first table and I forgot this form/report had this tidbit information from the first table. I would like to avoid all of these mishaps. I recall somewhere I could find this but I cannot put my finger on it now when I need it. Old Age, I guess. I hate turning %) Sincerely, Paul Dewey New Horizon Interlock Inc. New Horizon Safety Diagnostics Inc. www.interlockinfo.com Saving Lives - One Breath at A Time T This e-mail message is intended only for the named recipient(s) above and is covered by the Electronic Communications Privacy Act 18 U.S.C. Section 2510-2521. This e-mail is confidential and may contain information that is privileged or exempt from disclosure under applicable law. If you have received this message in error please immediately notify the sender by return e-mail and delete this e-mail message from your computer.
