Mia erwthsh se Access

[Pablo_Hasan]

exw kanei ena form kai thelw na balw drop down list se ena kel, pws ginetai?. Thn lista thn exw se table

[geob]

to "kel" ti einai ?

[drm]

Kel είναι το Cell. Νομίζω πως αν ο πίνακας που αναφέρετε το Cell (βασικά το πεδίο στο οποίο αναφέρετε) είναι dropdown τότε και στην φόρμα αυτόματα το control γίνετε drop down

[Maniakos]

Eukolo einai.Tha sou dwsw kai ena example.

 

1. Ftiaxneis ena main table to opoio exei ta eksis stoixeia

- id ( to opoio 8a einai kai to primary key sou me Automati Ari8misi)

- name ( to opoio kanto text )

- Sex ( edw 8a kanoume to drop down menu kai 8a deixnei Female kai Male. Auto kanto Text gia tin wra)

 

2. Kane save to table auto os main table kai meta kane create ena deutero table kai vale mono ena pragma , Description , to opoio 8a einai kai to primary key sou. Pigaine apo Design View se DataSheet View kai perase ston pinaka ta eksis : Male kai apo katw Female

 

3. Kane Save ton pinaka auton kai pigaine sto Main Menu tis Access kai pigaine sta RelationShips kai kane Relate to Sex field tou main table me to Description tou deuterou table.

 

4. Kane Save to relationship pou eftiakses kai meta pigaine sto DesignView tou main table sou. Pigaine sto Field tou Sex kai allakse to apo Text se Lookup Wizard , pata sinexeia Next kai sta Available Fields ama to exeis kanei swsta 8a exei to field Description to opoio kai 8a peraseis sta Selected Fields. Molis to teleiwseis kai auto kane save to main table sou pali.

 

5. Pigaine apo Design View se Datasheet View to main table sou kai ama epilekseis to Sex Cell 8a vgei drop down menu me tis epiloges Male kai Female.

[Pablo_Hasan]

maniakos: euxaristw gia thn apanthsh sou, nomizw o tropos pou perigrafeis einai o pio swstos.

 

to ekana kai alliws me th bohtheia enos wizard ths access.

8)