connecting records from two different tables

[boomerang boi]

is there a possibility to connect two different databases??? I mean is, I have a table called PERSON. under PERSON, there are fields called PERSON NAME, BIRTHDAY and ADDRESS. another table is called SEMINARS, under it are DATES FROM, DATES TO and TITLE.

I want to combine one of the records in PERSON to the 5 records in the SEMINARS. is there a possibility to do that???

to include in the information, there are 10 records in the PERSON and there are 75 records in the SEMINARS. and I want to add more records in SEMINARS in any of the records in PERSON in the near future.

 

[neileg]

A bit of terminology here. Database referes to the whole application. I think you mean two tables.

What you want to do is the core of any relational database so not only is it possible, it's vital. Every table should have a field that serves as a unique identifier - this is know as the primary key. Most of the time, this is a meaningless value that is only used to act as an internal identifier. Access provide the autonumber datatype which is ideal for this. To connect two tables you use this primary key. You need to create another field in the 'child' table to hold the link value of the 'parent' record in the other table. This field is known as a foreign key because although it is a key, it is the key from another table. If you have used an autonumber PK in the parent table, you would use an integer datatype in the child table.

Now just to complicate matters, you have a many to many relationship. Access can't model this with just two tables, you need to use a third table as an intermediate or junction table.

At this point you may be losing the will to live! I think this application is deceptively complex for a beginner. There are lots of posts in theese forums about booking and class attendance. I suggest you do some reading before you get too much deeper.