Easy Selection

Well, by easy selection, I mean a search function out of another table.

Im going to tell you how to do it with 2 tables, so you need to create these;

- Persons [Firstname/Lastname/Country]
- Country [Country]

* Table name [names it should contain]

now we gonna open the country table and add some country's in it;

Code:

Holland
Germany
Belgium
England
France

well everything is done in this table now close it and open the table for persons in design mode. (right click the table and you will see how to get in design mode)
Select the Country row and look in the bottom you should see searching.. click on it, now you should be able to click on selection list.
then you have to insert this into "RowSource" SELECT Country.Country FROM Country;
it means it has to show you everything from the Table "Country" and Items in "Country" so it would show us the country's we added in this table.
Close and save.

now if you open ure Persons table you will have this function:



goodluck and have fun.