Log of destinations

[316854]

I need to make a form and a query out of the sample data provided below.



In reality, there will be hundreds or thousands of customer identification codes and corresponding pieces of data.

TEMPLATE.
Customer identification code.
Surname.
Physical address.
GPS coordinates.

evfhvekeu
Smith
1234 N Main Ave Los Angeles CA 90001-1234
34.043019, -118.267256

evfhvekeu
Smith
2468 E Skyline Blvd Honolulu HI 96801-2468
21.289790, -157.835905

dqvzdaeee
Smith
9876 S Stone St Kansas City MO 64081-9876
39.097284, -94.579951

syxpffszj
Johnson
9876 S Stone St Kansas City MO 64081-9876
39.097284, -94.579951

ndmpmsqhk
Williams
3579 W River Ln New York NY 10001-3579
40.750515, -73.993456

I need the fields to include the following in this order:

Date (e.g. May 29, 2015).

Day (e.g. Monday, Tuesday…). This needs to be a calculated field (I want access to fill this in for me).

Order (e.g. 1, 2, 3…).

Surname (e.g. Smith).

Customer identification code (e.g. evfhvekeu). After I enter the surname and I tab to the next field, the field for customer identification code, I want access to provide me with a combo box of the customer identification codes that match the surname.

Physical address (e.g. 1234 N Main Ave Los Angeles CA 90001-1234). After I enter the customer identification code and I tab to the next field, the field for physical address, I want access to provide me with a combo box of the physical addresses that match the customer identification code.

GPS coordinates (e.g. 34.043019, -118.267256). I want access to fill this in for me from data I put in in another location in the database.


Thanks

[ranman256]

Build a table to store this data.
click the form wizard, tell it to make the form.

[June7]

What is data structure? What tables do you have and what fields?

CustomerID
Surname
Address
City
State
Zip
Latitude
Longitude
OrderNum
OrderDate

The comboboxes you describe are called dependent or cascading. Review: http://www.datapigtechnologies.com/f...combobox2.html

Why do you need the Lat Long on form?

Build a report that joins tables so related info can be displayed.