R
Rob Hofkens
Hello !
I have a simple form with adresses of contacts.
I have a problem with editing the form after I adjust the sorting.
Currently I have set the record source to SELECT * FROM tblContacts ORDER BY
Name;
This works fine but I also want the city name in the sorting.
The city name is stored in a big second table with all the city names of my
country.
So I use a CityID field in the tblContacts and link it to the table
tblCities.
To get the table sorted the way I like I would need something like this SQL
:
SELECT tblContacts.*
FROM tblCities INNER JOIN tblContacts ON tblCities.CityID =
tblContacts.CityID
ORDER BY tblContacts.Name, tblCities.City;
But when I use this as the record source then the form disables all Editing
and Adding![Frown :( :(](/styles/default/custom/smilies/frown.gif)
Is there any way how I could use the sorting I want and still be able to add
or edit the tblContact through the form?
Thanks in advanced!
Rob.
I have a simple form with adresses of contacts.
I have a problem with editing the form after I adjust the sorting.
Currently I have set the record source to SELECT * FROM tblContacts ORDER BY
Name;
This works fine but I also want the city name in the sorting.
The city name is stored in a big second table with all the city names of my
country.
So I use a CityID field in the tblContacts and link it to the table
tblCities.
To get the table sorted the way I like I would need something like this SQL
:
SELECT tblContacts.*
FROM tblCities INNER JOIN tblContacts ON tblCities.CityID =
tblContacts.CityID
ORDER BY tblContacts.Name, tblCities.City;
But when I use this as the record source then the form disables all Editing
and Adding
![Frown :( :(](/styles/default/custom/smilies/frown.gif)
Is there any way how I could use the sorting I want and still be able to add
or edit the tblContact through the form?
Thanks in advanced!
Rob.