I am trying to insert a record to a table but I am also needing to have the related Table to update also. But I am not able to add two insert records server behaviors so How do I do this?

Just FYI I have a dynamic menu for Cities and so I have the Cities as on table and the zip codes in another table and when I update the City table I am needing to get the Zip table to update also. So How do I do this If you need more facts just ask and I will post them for you.
Thank you In advance

OK First, Sorry to say this but you might want to combine the two tables together. because there is a SQL statement that should work. In the Recordset go to advanced and in the SQL statement put this in

SELECT DISTINCT City <this being you field>
FROM cities <this being from your table>

leave varibles blank run a test and it should get a response. What that does is looks for all of the distinct cities and then just displays that item once. I hope this helps.

If anyone else has any Ideas or if I am wrong (which I am well known for) please post and lets help each other out.

Alright lets try this again

Edited by - Circlecast on 07/18/2001 08:39:52

oh well OK I was not liking the db layout any how Thank you

Alright lets try this again