Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2002

    Unanswered: Implementing Lookup Table Form

    I've got a lookup table that identifies whether the entity is a child of one of two parent entities.

    Child ------< Lookup >------ Parent 1
    Child ------< Lookup >------ Parent 2


    The idea is that a child can only be the child of either Parent 1 or 2.

    Basically, I need to have a form that allows the Child table to be populated, adding the relevant stuff to the lookup so that its then linked correctly.

    Ideally, the Child form should be a sub-form within the one for the parent, so that children can be added whilst editing the parent.

    Once again, all suggestions would be greatly appreciated!

  2. #2
    Join Date
    Aug 2003
    Delft, The Netherlands (EU)

    Re: Implementing Lookup Table Form

    You have several options; take a look at the DB Explorer solution, maybe you can copy that idea.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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