Form with data from two tables and is editable...?

C

Confused87

I have two tables:

Marathons and People

I need all the data from Marathons and the address data from People.

I have created a query:

*Marathons, address 1, address 2 et cetera

I have created a form for this data - however, I need the user to be able to
edit it.
Do queries in their nature allow this? Is the Lookup function related to
this? Should I put all the address data straight into the Marathon table -
but then how will it be updated?

Please note that whilst I am beggining to understand code, I still find it
hard to get my head round, so if it is the only option, please explain in
full.

Many Thanks
Camilla
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mixing Table Data to Create a Form 1
Adding data to MS Access from csv file 0
Creating a Chart on form from selected data in query. 0
Help creating a search form in Access XP 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
DLookup in Continuous form 0
Editing records from two different tables on a single form 1
VBA Reference to Fields in Tables 9

Top