Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Upstate, New York, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relationships for subforms

    Access97:

    I have a form with a subform; on the main form I enter policy information, on the subform I want to enter exposure information for that policy. Each policy could have more than one exposure attached. I have set up my tables with the PolicyID field in both, and the relationship is one-to-many, Policies to Exposures. However, when I try to enter more than one exposure for a policy, I'm not allowed. The Rowsource for this form is a query where I've included all fields from the Policies table and only the exposure description from the Exposures table.

    Please let me know if I haven't given enough (or the correct) information. Any suggestions are appreciated.

  2. #2
    Mike B
    Guest

    Re: Relationships for subforms

    if you have a one to many relationship there is no need to use a query as the rowsource....use the exposure table as the control source of the subform....then link the subform to the main form using the PolicyID HTH

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Upstate, New York, USA
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationships for subforms

    Sometimes I'm amazed I can even grow hair on a head this thick...

    Thanks for the help, Mike.[img]/w3timages/icons/doze.gif[/img]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •