How to add extra fields (Meeting1, Meeting2, Meeting3, etc) while using the form

[bengboy]

Hi,



I've just today started to try to use Access, and would be grateful for any advice.

I would like to be able to set up a database to track multiple projects, but have two fields in the form that are 'Meeting 1 Date' and 'Meeting 1 Notes'. Then, next time we have a meeting about the project, I'd like to be able to click a button on the form to add 'Meeting 2 Date' and 'Meeting 2 Notes', then subsequently return to that record and add for meeting 3, 4 and so on.

How on earth can I do this? Is it possible??

I am not at all familiar with Access yet, but have been trying to learn some of the basics & terminology today. So if you can help, please keep it simple!

Thanks a lot,

Ben

[pbaldy]

You don't want it set up that way. Meetings would be in a related table, with 1 record per meeting. The concept is called normalization, and it's critical to database design. One link among many:

Fundamentals of Relational Database Design -- r937.com

[bengboy]

Thanks a lot. I was beginning to realise there would be another way but didn't know how to describe it / the terms for what I wanted to do. Will spend some time going through that link...

[pbaldy]

No problem. The study will be worth your time. Properly normalized tables are the foundation a database app is built on.