creating a data entry form

  • Thread starter Thread starter KS
  • Start date Start date
K

KS

I am creating a database for the work i am doing that has
the folloing fields: International stock exchange code,
company name, country, years of data, financial year end,
groups.

For there is data for many countires and groups, what i
want to to is crate an input from to put the data in where
when i select the country it refins the list of groups it
can go in to. Some sample data below

company x australia ASX50, lonsdale
company z australia ASX50
Company w canada TSX60

I want to use a combo box to display the choices of
countries and groups avaiable.
Any help would be much appricated.
 
This looks like what i want, but I am unsure how to apply
it is there an example, of how to do this.
 
Hi,

I think you should create two tables such as: country and
company.

In the company table, you should create a
field "countryID" with property "number" and lookup to the
table country

After that, you link two table with one to many
relationship (one country to many company). In this case,
you could create a form with two table and with one
country you could see many company (form/subform)

Best regards,
Kiet
 
Back
Top