Sajid -- ...and then Sajid said... % % Hi,
Hi! % Thanks for your help. % But what i feel is that this is a more tedious process to achieve what i % want to. Sometimes database work is :-) % What will happen in this is that i have to enter proper Continent ID and % Country ID in both Country and Club tables respectively. That's true. If you want a club to be in a particular country then you'll have to specify what country. How else could you do it? % For that i have to go and check that these ID's are in the other tables. Ahhh... Now you're talking about 'foreign keys' in your relational database. This ensures that, should you change the country ID in the country table, all of the clubs for that country will be updated. You'll still have to enter the country ID, though, whether manually, through a pulldown, or by matching text. HTH & HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg!
pgp00000.pgp
Description: PGP signature
