Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Montreal, Québec
    Posts
    10

    Unanswered: Help with Table&Form design

    Here the trouble :
    The Table :
    - Command : PrimaryKey : IDCMD and [...] and FKIDEXP (ForeignKey)
    - Expedition : PrimaryKey : IDEXP and [...]

    The relationship :
    An Expedition can take one or more command
    A Command is on one and just one Expedition

    I have to apply integrity.
    First I want to complete my form command and all info related to...But at this time i dont know which Expedition my command will have. So i Can't assign my IDEXP ( As FKIDEXP ) and if i don't assign this i can't be able to save my command...

    I want to be able to fullfil my command, and after on another form
    (FRMExpedtion) Enter info of my expedition and Add all IDCMD related to this expediton....

    Somebody can help me ?
    I'm sorry if i'm not clear or if i make a lot of faults... i'm not english
    Thx

  2. #2
    Join Date
    Aug 2003
    Location
    Montreal, Québec
    Posts
    10
    i think i've got an idea !!

    if i assign a "NOEXP" value by default, i will be able to save my command, and later i just change the value by the real expedition !


    Is it the better way to do this ?

Posting Permissions

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