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