Visit Visa

[rascot123]

I would like to create table and form in msaccess.
Fields are as follows :
ID
COUNTRY
TYPE OF VISA
DATE
RATE
DOCUMENTS REQUIRED
type of visa for example for Dubai itself will be 4 categories.
tourist visa 1 month
tourist visa 3 months
leisure visa 1 month
leisure visa 3 months

What can I do in this situation. Can I create drop down box? How?
in the field of COUNTRY? Otherwise is there any other way?
Please comment.

 

[Ranman256]

EVERYTHING is controlled by tables.
To fill a combo box, make a table with all the items to fill it,...like duration
months
days
years

Type of visa: the table will contain
tourist
leisure

in the form, put the combo box, attach the table to the source list.
This is basic Access design. Please read up on this.

 

[Uncle Gizmo]

This question is fractured, sort of a double post..

http://www.access-programmers.co.uk/forums/showthread.php?t=290300