Information générale
Catégorie:
Codage, syntaxe et commandes
>>This: Some of them are complaining because they're having to add cities to the Cities table that may only appear in one (e.g. Obscurityville as opposed to Philadelphia which is in the table and used frequently). Personally, I don't see this as a huge problem, but...I can't figure out a way to let them add a city to the address table w/o adding it to the Cities table and still keep my row source as Fields so they can use the incremental stuff. Am I out of luck, or is there something really obvious I'm missing.
>>
>
>You can't do this with the rowsourcetype as fields. But you get around it by making the rowsourcetype = none, and populating the combo from the cities table. That way, the uesr can add anything they want.
>
>SELECT Cities
>SCAN
> THISFORM.cboCities.AddItem(Cities.City)
>ENDSCAN
>
>You'll have to adjust the code that joins the cities and address tables though, to have it look at the displayvalue of the combo instead.
>
>HTH
Thanks for the tip Eric. I'll try working with this a bit, and see what I can mess up:)
Sylvia
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement