Hi

I've have created 3 tables. One of these is the main table which holds all of the information I need to know for the events i'm organising this year. these include details such as wheere they're being held, whose working, whether it needs catering etc. I have now created 2 other tables, 1 called 'correspondence' and the other 'booked ambassadors'. Both of these tables hold extra information that i would like to view from the main table but are something that is not visible form the outset (otherwise it would be a very big table!) Now I have already created these tables could you please tell me how to link them togther, adn also from my explanation do you think this is the easiest wa to show this infomration?

Thank you for your help.

regards,

Emily

Hi Emily

Thank you for your question. We cover table reationships in our Access Intermediate course. Also bear in mind that to create effective relationships it does take time and understanding. You may go through several versions of trial and error in trying to create what you are looking for.

We also offer consultancy which mean that we can supply a trainer / consultant to assist you with the creation of your database. Our rates start at £650 per day.

Here is a simple outline of creating relationships, however, you do need to bear in mind that the structure of your tables influences the way the relationhsips are created and work.

In Access, click TOOLS > then RELATIONSHIPS. The tables in the database are shown, and to create a relationship, click and drag a field in a table and drop it onto a field in the table you want to link to.

To understand more about the process, you can look at topicsin help like:
Creating database relationships (the process)
Normal forms (organising data in tables)
Referential integrity (how data in one table relates to a another field in a different table based on the relationship).