Cascade Delete Related Records with code

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Frontpage Programming
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Linking Drop Downs in FrontPage based on SQL DB I have a table in SQL that Links our States with our Restaurants. I want to create a dropdown box that queries the states, easy enough.. however when the user selects a state, I want the next dropdown to display the results of only those restaurants in those states. I guess this is similiar to a chained dropdown box using a javascript.. but I want this to link to a sql table Tag: Cascade Delete Related Records with code Tag: 65264
  - 2
    - Date and Time Picker Hi I am trying to use the "Date and Time Picker Control 6.0 (SP4)" in a FrontPage webpage form to return the date selected by the user in a Access database. How can-I return to the database that value. I get an empty field. What variable can-I use? Tag: Cascade Delete Related Records with code Tag: 65257
  - 3
    - Live Spaces and Frontpage Hi! I have just generated a new web site with Frontpage 2003. Now I want to integrate a blog in my website. I have opened a new space in Live Spaces. What are the possibilities to integrate my Blog (of Live Spaces) directly in my website? thanks in advance Bizi Tag: Cascade Delete Related Records with code Tag: 65255
  - 4
    - site map F.P. 2003 Can you recomend the best way to go about putting a site map on my e-commerce site. Thank you for all yoour help. Billy Tag: Cascade Delete Related Records with code Tag: 65250
  - 5
    - frontpage save pages as 20% - how can I get rid of that format? frontpage will place 20% into a web page title. Sometimes it does, sometimes it does not. Any suggestions. Tag: Cascade Delete Related Records with code Tag: 65246
  - 6
    - stuck on form mailer I have a website that I created with Frontpage 2003 and I purchased a SSL Certificate. I found that the Frontpage forms weren't supported with the SSL. I asked my Hosting company (godaddy) if they would install extensions on port 443, but they said that they couldn't, so they pointed me to directions on how to point to their gdform.php, which I did. The form now works on the secure page, and I receive the email with the data input, but, once I click on the Submit button, I receive the error.... "You are about to be redirected to a connection that is not secure...... " I changed the redirect for the confirmation page from: <input type="hidden" name="redirect" value="thankyou.html" /> to the following.... <input type="hidden" name="redirect" value="https://www.mywebsite.com/thankyou.html" /> but then I get the "Ooops, Page not found error". I realized with redirect line above, is actually redirecting to the following URL which is why I'm seeing the "Oops, Page not found error". http://www.mywebsite.com/https://www.mywebsite.com/thankyou.html (notice the string of two urls together...one http, and the other https) If I remove the redirect command for the confirmation page completely, I still get the "You are about to be redirected to a connection that is not secure...... " error. What would be the correct redirect line, to redirect people to the secure thankyou page so that they don't get the "You are about to be redirected to a connection that is not secure...." error ? The line I tried below, is obviously not giving the correct results. <input type="hidden" name="redirect" value="https://www.mywebsite.com/thankyou.html" /> The post command I am using is: <form action="https://www.mywebsite.com/gdform.php" method="POST"> Thank you for any help you can give me. Pam Tag: Cascade Delete Related Records with code Tag: 65245
  - 7
    - FP 2003 Discussion Board (Want to hide remote name) I am setting up a intranet site for my company. I am using FP 2003 and in the site I have setup a discussion board. In the Discussion board on the results of the post i get this: From: user Date: date Time: time Remote Name: 00.00.00.00 I want to hide the remote name from the user but I need to able to view the remote name availible if i user post explicit content. Any thoughts? Tag: Cascade Delete Related Records with code Tag: 65244
  - 8
    - I have a problems in authoring (browser) JavaSript need to open? I have a website using third party because of a search engine. they told me to change my browser to Firefox instead of Internet Explorer because my problem is the JavaScript was not in the FrontPage or it is locked. I went to Page Options and look the authoring, I've notice that the JavaScript on Browser column was not checked, is this the problem why I can not publish my website to IE properly? If can somebody go to my website, www.cruizes.net, click on Just Cruises & Tours, then click the Cruises, try to use the search engine, I'm getting a different results. I've talked to Revelex the third party, I'm not a web designer or a programmer I'm just trying to work my website. I did what I can I'm running into a dead end street. Please help!!!!!Thank you. Michael Tag: Cascade Delete Related Records with code Tag: 65243
  - 9
    - dynamic HTML Effects I have copied from the web very simple instructions on how to create rollover images. To create a Rollover I am asked to 'select the Dynamic HTML Effects option from the Format pull-down menu'. I don't have this, only Dynamic Web Template. I am not well versed in jarva script so simple explanations would be appreciated. Also I only have design, code and preview in my task bar, not 'normal'. A search for updates showed that I didn't need anything. Am I doing something wrong. Tag: Cascade Delete Related Records with code Tag: 65241
  - 10
    - DTPicket control I am trying to use the "DTPicker" control to collect a date value from a form in an asp page. How do I format the control to return the value in my Access database from the form? Tag: Cascade Delete Related Records with code Tag: 65239
  - 11
    - Difficulty adding records to a Access database through frontpage Hi all This has been posted somewhere else too. i thought i would try posting it in more places and organize the problem a little better. My system is running WinXP pro, IIS5.1, FP2003. I have successfully created and imported a database into the web. I have also successfully accessed and displayed the records in the database using a combination of DRW and direct manipulation of the asp code. The problem is trying to add records to the database. I have tried directly creating a form and making sure that the form fields and database columns match. Connections were also verified. I accessed the form through the browser and added a record. The operation completed successfully, however, no data was actually recorded. I have also used the DIW to no avail. Same problem, successful completion but no data actually written. I have seen the KB http://support.microsoft.com/default.aspx?scid=kb;EN-US;219158 However, that did not help. A step-by-step of one of the methods I have used is: 1. Create a new database (test.db) with one table (Results), two fields, an autonumber field for the primary key, and another field which I have called value1. The field value1 was set to text with default values. 2. Imported the database into frontpage, which was placed into \fpdb. The necessary connections were verified. 3. Create a new page and named it test.asp. 4. Inserted a form using Insert | Form | Form. 5 Inserted a text box using Insert | Form | Textbox. 6. In the textbox properties, changed the name to value1 and the rest of the selections set to default. 7. In form properties, selected 'send to database' 8. In form properties, saved fields, ensured that the formfield and database columns matched, i.e. both are value1. 9. In IIS, I selected the \fpdb directory and checked, script source access, read, write,directory browsing, log visits, and index this resource. 10. Open test.asp in a web browser and key in information. Here I have entered 'one1' into the lone textbox. hit submit and get a confirmation page. 11. Open test.db and nothing has been added. I have also tried letting frontpage create a database and connection too. From what I understand, this will prevent any errors related to form field and database columns not being exactly the same. This did not solve the problem, i.e. I still get a confirmation without any data actually being written into the database. I next tried sending the form data to a csv file and a text file. Upon entering the data into the text box and hitting submit, no default confirmation page was displayed, and neither of the files contained any results. Does this mean that I have a configuration problem? I checked the permissions, and I have gone to the extent of making all folders and its contents read, write, and executable. I have further completed an uninstall and a reinstall of IIS. I am in need of any suggestions and ideas. Thanks Chin Tag: Cascade Delete Related Records with code Tag: 65236
  - 12
    - In FrontPage 2003 how can I make a paragraph scroll like credits? I am trying to make some information scroll from the bottom to the top of a cell like movie credits. I can't find a way to make it work. Can anyone help? Tag: Cascade Delete Related Records with code Tag: 65234
  - 13
    - How do I set a photo to automatically change to a different photo I need to add a gallery of five pictures on my home page. I want each one of those pictures to change to a different set of pictures after a specified amount of time (e.g. 2-3 seconds). The pictures are not linked to anything, they are merely for aesthetics, but I want them to change automatically without any other behavior attribute (e.g. mouse rollover, click, etc.). How do I accomplish this task? Tag: Cascade Delete Related Records with code Tag: 65231
  - 14
    - Email Bot Assistance I am creating my first web site. My host allows me up to 100 email accounts and many family members have expressed the desire to have me host their email (with a family name domain). The web host has a horrible front end to their web based email. It is POP and SMTP compatible. It is FrontPage compatible and they actually recommend using FrontPage for the front end. I have looked and have not yet found an example of a web-based email page that I could plagiarize for use on my site. Your help would be greatly appreciated. Tag: Cascade Delete Related Records with code Tag: 65229
  - 15
    - How can I stop column width auto extending I am novice at frontpage or even webdesign. I have started with layout table - not convinced it is any better than nested tables. Anyway, I have inserted tables within these and would like cells that stay width fixed and height auto extending. Whatever I do the width changes as I reach the end of the column while typing. How can i stop it doing this. Thanks Paul Tag: Cascade Delete Related Records with code Tag: 65226
  - 16
    - Adding secure credit card payment page How do I do this? What info do I need? (The organization has been set up with a company to be able to accept credit card donations) Thanks Tag: Cascade Delete Related Records with code Tag: 65220
  - 17
    - Site map Front page 2003 Is the site map that F.P. shows you how to build hold the same value for search engines as the site map generator offered by google and others. Thank you for your help, Billy Tag: Cascade Delete Related Records with code Tag: 65216
  - 18
    - How do I add a downloadable audio file (mp3) to a web page? I would like to put buttons or links so vistors can download audio. I will most likely use mp3's. Can someone tell me how to accomplish this? I am using Front Page 2003. Thanks! Tag: Cascade Delete Related Records with code Tag: 65204
  - 19
    - better way for renaming a folder? Hi, Thanks for the advise in advance. Suppose folder A is going to replace all contents in folder B. What will be some other alternatives other than renaming folder A's name to folder's B (and folder B's to other name)? Background information: We recently upgraded a shopping cart software, and for the safety reason, we created another folder (folder A) for the upgrade and testing while keep the original folder (B) intact. After everything is being completed and pointing database to the new one, we renamed folder B (original shopping cart) to another name and folder A to folder B. The process went through fine and almost immediately switched over without anyone notice. But the problem with this approach is - when we renamed folder B to another name (se. C), all contents inside folder B changed its reference to C. We wish to retain all references as it is so that it can be used as back up. In this case, we had to use Find to serach the entire folder (many contents) and replaced all references of the new folder name (C) to the original one. This is very time consuming. So the question is - is there a better approach other than using renaming for switching contents of the two folders, or if is there a way that can retain all references intact during renaming? The software used is FrontPage 2003. Thanks in advance. Tag: Cascade Delete Related Records with code Tag: 65200
  - 20
    - email list Is there a way to set up a "join our email list"? Also would this be done with a list bot? Tag: Cascade Delete Related Records with code Tag: 65196
  - 21
    - Website optimization F.P. 2003 Utilizing natural optimization, requiring rich in text content and keyword density of 5% or less. When viewing page rating with an optimizing program, header navigation and side navigation text shows first then my page content increasing total text making it impossible to make the 5%, unless I repeated my keywords to the point of nonsense. Building the site with borders, is there anyway to hide the borders from search engines or should I have used frames or a blank page in the begining. I'm stuck can you help me. Thank you, oblio Tag: Cascade Delete Related Records with code Tag: 65194
  - 22
    - Automatically Generate Links Is there a way to create a web page, I'm guessing it would be ASP, not sure though, that would automatically create hyperlinks to files in a given folder. For instance, I have a folder that contains various forms. I'd like to have a web page people can go to, have the forms in that folder listed automatically, and click on one to open it. The forms are PDF files, if that even matters. Thanks! Tag: Cascade Delete Related Records with code Tag: 65193
  - 23
    - After submitting form, conformation page sends to blank page,why Why does my conformation page send visitors back to a blank page? Unless the visitor clicks the back button on their browser they go to a blank page. I have merchant pay button, when it is clicked is goes to the conformation page and not to my merchant account, any idea why? Tag: Cascade Delete Related Records with code Tag: 65184
  - 24
    - Database Replication or Dual Table Submission By using the DRW, is there a way to submit data from the form to two different tables or databases from one submission? I would like to have table 1/database 1 be editable through a backend while keeping all the original submissions stored in a second db or table. Can this be done through Frontpage? Or... getting more technical is there a way to replicate a table on the web server where once data is submitted the table replicates it self to another table in the same db or to another db all together automatically? Thanks... Tag: Cascade Delete Related Records with code Tag: 65181
  - 25
    - Image/Path/Red Xs Hi. I am working in MS FrontPage 2003. I have an HTML document that appears fine in FP. The problem occurs after I uploaded it to my web host and view it: the background design is gone--it is now white, and the images (.jpg and .gif) are replaced by the dreaded red Xs. I have heard of the image path being set locally and this being a possible reason for the problem. How do I correct this local path problem? Thanks much, John Tag: Cascade Delete Related Records with code Tag: 65171
- Next
  - 1
    - error 500 can anyone tell me why I am still getting an error 500 message at the end of uploading my site to my IP this is continued with an error 401 script Tag: Cascade Delete Related Records with code Tag: 65166
  - 2
    - Photo Gallery Problems I use a lot of pictures in my husband's website; therefore, I loved FP Photo Gallery. The problem now that I am facing is I am unable to remove my pictures from the gallery when needed. I thought it was my computer, so I loaded FP onto a different computer and it is doing the same thing. I click on the PG Properties, and not only does the pictures that I have on that page not listed in the left hand box, but it says that I have 0 pictures in my gallery and I have 7. I am looking into JAlbum, for the simple fact that we do post a lot of pictures, but I am not familiar with it, and I don't know how to intergrate it into my website. Any help would be great, or if anyone else has experienced the same issue, that would be great too. Thanks for all your help Tag: Cascade Delete Related Records with code Tag: 65163
  - 3
    - Link from one data Results page to another data Results Page? Hello-- We built a FrontPage 2K3 Web site that includes a form. We used the FP2K3 database feature to create an Access 2K3 single table database connected to the form. Additionally, we created two .ASP data Results pages where we display data results on the Web site. One results page displays a brief Summary of the data, and the other results page displays Detailed detail of each record. Our problem? How do we build a hyperlink from a field ("Job ID") in the Summary data Results page to link to its counterpart field in the Detailed data Results page? Making sense ..? E.g., we want users to be able to click on the Job ID link in the Summary page and be taken directly to the other Results page to see the Detailed data about that same Job ID number. Thank you very much for any assistance you can provide -- Best, 8web Aug 11, 2006 -- Tag: Cascade Delete Related Records with code Tag: 65161
  - 4
    - Shopping Carts - StoreBot 2005 Does anyone have any experience with StoreBot 2005? It's a shopping cart that claims to integrate with FP 2003. -- Tom Richards tom@webhandprintSPAM.com http://webhandprint.com http://brainsturgeon.com Tag: Cascade Delete Related Records with code Tag: 65160
  - 5
    - Survey Form Conditional Nav Developing a web-based survey form. If users answers yes to question 5 then I want them to be directed to question 15. If no, then continue to question 6. I'm using a dropdown menu for the response to question five and passing a numeric value to an .mdb file on the backend. I did quite a bit of VBA programming several years ago, but I'm rusty. If someone could point me in the right direction I'd sure appreciate it. Thank you, -- W. Randy Rice, MSHA Tag: Cascade Delete Related Records with code Tag: 65153
  - 6
    - How do I create a wish list with FrontPage? I am wondering if there is a way to create wish lists for your customers in FrontPage? Tag: Cascade Delete Related Records with code Tag: 65152
  - 7
    - Caption and Description in Photo Gallery Not Showing Up I am using Front Page 2003. I create a photo gallery (any type except for montage) and type in a description and a caption. I click OK. It says Generating Thumbnails for photo gallery. If I immediately go back the description and caption are missing where I originally put them as well as on the web page. http://www.fossilcreekestates.org/society%20pages.htm Tag: Cascade Delete Related Records with code Tag: 65146
  - 8
    - Search table for multiple elements I maintain a public school district web site, and would like to post our bus list in a searchable format. The list is currently in excel (1 row = 1 record) and includes school name, bus number and street name for stops. Is there a way to post this information and search by any (or all) of these elements? Tag: Cascade Delete Related Records with code Tag: 65144
  - 9
    - How to set up .htaccess file in frontpage to allow php includes I'd like to know how to set up and include an ".htaccess file" in frontpage 2003 which will allow php includes on my .html pages. I'd like to include a feed on my webpage Could someone please give me the process for doing this and be specific as I have little experience with script other than what I've read in the Microsoft Office Frontpage for windows 2003 text. Thank you. Tag: Cascade Delete Related Records with code Tag: 65141
  - 10
    - using watermarks I have been trying to use watermarks on 2003. The jpg image repeats on the outside boundary of the web pages. What wrong? The code: <body style="background-image: url('Hoist-Rack-2.jpg'); background-attachment: fixed"> Tag: Cascade Delete Related Records with code Tag: 65138
  - 11
    - Printing over Internet I am using Microsoft FrontPage 2003. Using this and/or with an addon, is it possible to create a form that when it is submitted it will print on an internet connected printer at my clients office instead of going to a database or email address? Thank you Tag: Cascade Delete Related Records with code Tag: 65137
  - 12
    - Editing Hyperlink Styles I am developing a personal site from scratch using FP 2003. I have placed navigation words/phrases (such as "Home" and "Photo Album") on the pages. The words exist in several places on each page and are in different colors and font sizes. When I set up a hyperlink to facilitate navigation, FP defaults to changing the font to blue with an underline. I do not want this to happen... I know that you can change the color of the hyperlink text for the entire page - not helpful for my situation given the differing colors of the text used. Plus, I do not want the text to be underlined. Here is my question: is it possible to disable the default underline and color change for a hyperlink? What I would prefer to happen is that the text with an accompanying hyperlink does not look any different until it is scrolled over. At the moment the text is scrolled over, I would like the hyperlinked text to either turn bold (or un-bold as the case may be) or become underlined to indicate the presence of a link. I appreciate any suggestions on this... Tag: Cascade Delete Related Records with code Tag: 65127
  - 13
    - Positioning Relative to window I have a graphic along the bottom of my page, It acts as the base line to my page. I want this to always rest on the bottom, regardless of the resolution of the screen. I beleive this is possible with absolute positioning and percentages. However, whether I type 0% 50% or 100% to define the "top" property it ends up at the top of the page rather than resting on the bottom. Any advice or a differnet way to get the same result would be greatly appreciated, Thanks! -MIKE- Tag: Cascade Delete Related Records with code Tag: 65116
  - 14
    - Where to start? How to create a "Navige structure"? I am going to design a web site using frontpage, but not sure where to start. According to the help of frontpage, its better to design a "Navigate structure" first. The help files described a lot about how to add, remove, modify the "Navigate structure", but I cannot find any instruction about how to create the "Navigate structure". ("Navigate structure" is what I translated from Chinese help document of frontpage, I don't know what's the correct English for that, it's a structure that determine the whole web site structure, which is the parent page, which are the children page, ...) I opened frontpage and clicked the button "Navigate" in the left bar, and then stopped there, have no idea what to do next. Anyone can tell me how to create the "Navigate structure"? Thanks! Tag: Cascade Delete Related Records with code Tag: 65115
  - 15
    - FrontPage 2K3/Access 2K3: Form Output not retain original text for Hello, We built a FP2K3 Web site with several forms, and used FP2K3' built-in feature to create associated Access 2K3 databases connected to the forms. We then used the FP2K3 DB Results feature to display the form results onto .ASP pages. That all works fine. Except for the formatting of the text in the Results pages -- there is no formatting, just plain unformatted text. We need to be able to have the displayed text retain its original input text formatting, e.g., paragraph settings, font, character attributes (BOLD, Italic etc), carrage return, line feed et al. Have tried to enable this from within Access 2K3 -- in the results table -- but unable to do so. Can you help us please? Any/all assistance would be greatly appreciated. See one of the forms at: http://www.trg-reger.com/forms/forms_employmt_openpositions/employment_positions_results5.asp Thank You! 8web Aug 9, 2006 ........................................ Tag: Cascade Delete Related Records with code Tag: 65113
  - 16
    - Want to change the apperance of task bar how it's possible? M using Ms-Frontpage2003 and want to change the text in taskbar.Very simple wanna personalize my task bar if possi pls tell how to create marquee for taskbar too. Tag: Cascade Delete Related Records with code Tag: 65107
  - 17
    - Link Frontpage with SQL Server. Hi: I am tryin to create a form which access database in SQL Enterprise server. But, for some reason, it is not inserting records into the database. Could you please suggest? Thank you Vinay abburi Tag: Cascade Delete Related Records with code Tag: 65106
  - 18
    - Excel spreadsheets in FrontPage websites I created a website using FrontPage 2003 and to add search capability for an inventory, I inserted Excel spreadsheets with autofilter activated. Although I can do searches exactly as I want them to, visitors to the site get an error message regarding Web Components. Any solutions to this? Has anyone else experienced similar problems? Tag: Cascade Delete Related Records with code Tag: 65103
  - 19
    - ASP and HTML file types in my website I keep getting the error message of "the following pages in your web site are active server pages (asp). They may not work because the server you are publishing to does not support asp. What do I do? Can I convert the asp files to html? Please help!!! Tag: Cascade Delete Related Records with code Tag: 65101
  - 20
    - sub web I am having a hard time understanding a sub web and how it works. Can some one enlighten me, please? Tag: Cascade Delete Related Records with code Tag: 65097
  - 21
    - delete all the files in a folder I want a VBA macro which deletes all the files in a folder! -- Varun Nair Tag: Cascade Delete Related Records with code Tag: 65092
  - 22
    - shopping cart Are there any shopping carts that are easier to add using Front Page 2003? Bonnie Tag: Cascade Delete Related Records with code Tag: 65091
  - 23
    - excel component in FP 2002 I used Excel to make a component spreadsheet to hold some data (1100 records) to just be displayed in a FP web page. Apparently this only works if you have MS Office and/or Excel on your computerto view it. Otherwise a little square box appears and nothing else. How do I program in an error message for those that don't have Office on their computer so they will know this is the situation? Thanks Ron Tag: Cascade Delete Related Records with code Tag: 65088
  - 24
    - Placing a ListField value into an IFRAME URL I have a Sharepoint Services website that I am editing with Frontpage. I have a hyperlink field (assigned in sharepoint) for Server Status. When a user clicks on this link, it sends them to the URL value that I typed in when I filled out the Sharepoint form. By right-clicking in sharepoint, I can select Insert List Field and select the field I want to use through a text dropdown. I am trying to create an Iframe with the value of that field in it. For the List Field, frontpage is generating the following code: <ows:XML><Field Name="Guest_x0020_Server"/></ows:XML> I need to somehow capture this URL and put it into my iframe. <iframe name="I1" height="100%" width="100%" src="???????????"> Can anyone help me? Tag: Cascade Delete Related Records with code Tag: 65087
  - 25
    - FP 2002 link bars How do i get the link bars from a child page to be differnet from the level above? When i changed the link bar properties on the child page it changed for all pages above that level. Thanks Ron Tag: Cascade Delete Related Records with code Tag: 65086

I figure there must be a fairly standard way to handle deleting related
records in different tables with code. I know you can set the Cascade Delete
Related Records when setting up the relationship but I already have records
in one table and not the other which keeps me from setting this now. I would
think the perferred way to handle it with code anyway. Does anyone know of a
bit of code that shows how to do it? Also I'm having trouble getting a sub
form to work correctly when there are no related records in the sub form
records. I want to be able to add the records thru the sub form but the form
doesn't show up anywhere there are not already related records? Could someone
please explain why this happens?

Thanks!!!!!!!!!!!!!

Top

Re: Cascade Delete Related Records with code by Ronx

Ronx
Thu Aug 17 03:09:36 CDT 2006

You may be better posting this in an Access newsgroup or forum - unless you
are querying the database through ASP pages, in which case a subform is not
relevant. As stated, your problem is not FrontPage related.
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/

"Tom G." <TomG@discussions.microsoft.com> wrote in message
news:B4FD37C8-35F7-4F19-B6BF-33E5EF402D91@microsoft.com...
>I figure there must be a fairly standard way to handle deleting related
> records in different tables with code. I know you can set the Cascade
> Delete
> Related Records when setting up the relationship but I already have
> records
> in one table and not the other which keeps me from setting this now. I
> would
> think the perferred way to handle it with code anyway. Does anyone know
> of a
> bit of code that shows how to do it? Also I'm having trouble getting a
> sub
> form to work correctly when there are no related records in the sub form
> records. I want to be able to add the records thru the sub form but the
> form
> doesn't show up anywhere there are not already related records? Could
> someone
> please explain why this happens?
>
> Thanks!!!!!!!!!!!!!

Top