This should be easy for you... (I hope)

[michaelreaves]

Hello,

I'm beginning to use MS Access 97 more and more every week, and I need some help as I work through learning how to develop databases.

This time, I need to be able to use one form to modify and create new records in up to 7 tables at a time. I'm not experienced in programming (well, except HTML and beginning JavaScript), so please be easy on me... I'll give examples to make this easier on you:

I have a table with names, a table with addresses, a table with phone numbers, and a table with interests. I want to use one form to enter info into all 4 of these tables. How do I do this? Do I need to make relationships? If so, where? Please reply to this message, and as well send a copy of the reply to:
m_r_productions@yahoo.com

Thanks in advance for any help...
MICHAEL REAVES

 

[gcole]

Create a query by adding all of your tables and selecting the fields you need. You can make your relationships by dragging from one table/field to another. Look at the resulting table to see if it is the data you want. Then create a form using the query as the data source.