Adding records through a form

[Neil_Pattison]

I have a number of tables all with there corresponding forms. I am needing to have a command button on the form for the user to easily add a new record. Obviously this is easy by just using the wizard but my problem is that I need the record to be added over all the tables.

This is an attendance database with tables for each month. So when a new member of staff joins and there record is added for that particular month I would like it to be added to all subsequent tables as well. Is there a way of doing this. It would also be beneficial if a similar thing could be done for deleting staff (i.e. a staff member is deleted from one table and subsequently is removed from the other tables)

Any help with this would be greatly appreciated

 

[MStef]

Hello Neil!
You don't need the same data in many tables. I think you have to learn something about DATABASE NORMALIZATION.

 

[Neil_Pattison]

At the moment I have a table for personal details with a unique staff ID and then other tables for each month which has fields for the unique ID and then fields for each day of the month. If I didn't have different tables for each month then there would be massive amounts of fields within the one table which would you say was the better way

 

[ducker]

if each of those months have the exact same type of data/information stored in them. I'd combine them in to one table and then have a crossreference table between your personel table and your "meetings" table.

 

[MStef]

Hello Neil!
I see you are a beginner in Access.
Look at "DemoNeilA2000.mdb"
Open "frmPersonalMain".
Try to find something about DATABASE NORMALIZATION
on internet.

(MStef alias Štef)