no problems Kiara,

I have solved it using DAL access layer

'********** Insert a record into another table ************

set dal_table=dal.Table("Maps")

dal_table.Value("Latitude") =values("Latitude")

dal_table.Value("Longitude") =values("Longitude")

dal_table.Value("Fall_ID") =values("Fall_ID")

dal_table.Add()

hi, Kiara,

the above setup somwhow omits the Map.Fall_ID from the list of primary key fields when application is build, is it because the detail table is set as follows:

Maps

ID

Fall_ID

Lat

Long

should I...

Hi, Kiara,

select

waterfalls.ID,

waterfalls.Fall_ID,

waterfalls.Latitude,

waterfalls.Longitude,

Maps.Fall_ID AS Map_ID,

Maps.Maps

FROM waterfalls

INNER JOIN Maps ON waterfalls.Fall_ID = Maps.Fall_ID

like this?

yes, Kiara, you understand correctly, but i do not know how to do that.

I ma a total new be to the SQL 🙂

Hi, Kiara,

i am almost done with the project of mine. in an hour or so i would send a message for you to see the actual data.

I will try both...

of course it would be as another solution to just enter manually data into Maps long/lat bu 10000 records are too much to enter 🙂

here they are

give me sec please, i am making the screenshots for you to see.

Hi, Kiara,

I have uploaded the attachment in the mdb format.Thank you so much.

If you are able to see it online it looks like this right now

http://demo.asprunner.net/a_pehlevi_hotmail_com/mapping/menu.asp

click on the...

ok, thank you for helping me figuring this out.

The database is very very simple I am going to give you an example set:

Table1 (master)

ID-----------------1

Location-----------Alaska

LocationID---------alaska001

Lat----------------65.730626

Long----------------154.160156

Map-------------this will be displaying lat/long asa google...