PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Linking files
Linking files
Iniciado por develop, 05,ene. 2004 15:11 - No hay respuesta
Publicado el 05,enero 2004 - 15:11
Hello experts,
As (WinDev)layman I hit upon this : I have defined the following 3 files
- A='participants' with one unique key : ParticipantsCode (String 15)
- B='trip main-info' with 2 non-unique keys : Year (Numeric) and DestinationCode (String 4); 1 composite key : Year+DestinationCode
- C='trip participants' with 3 non-unique keys : Year, DestinationCode and ParticipantsCode ; 2 composite keys : Year+DestinationCode and Year+DestinationCode+ParticipantsCode
At the link description of B to C :
- one B to one C => No
- one B to several C => Yes
- one C to one B => No
- one C to several B => Yes
I confirm Check integrity (le fichier ?? Is that Scottish dialect?).
Then WinDev want to create a relation file between B and C.
What is the way to prevent this?
When I go further I got some other messages :
- the composite key in B (C too) will not be a composite key in the relation file
- Foreign keys in relation file cannot be identical
Who can give a (some) hint(s)???
Thanks,
Teun van Unen - Holland