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