Linking tables in Access

Factual Questions
1

I have used Access and like it. I have never used it to link data, I have always imported it.

Anyway I have a database that is divided by lots of tables. In one table lies the accounts. The other has the bookings. One Account can have one or 100 bookings.

I joined the tables and the problem is let’s say the Mark account has 10 bookings. 5 are called Mark and 5 are called Mark’s lunch. The query will return only the bookings that are exactly the same as the account name.

The joined link between the tables on the relationship says indetermainate. I am assuming that is you can’t do a one to many link when you link to a database and not import the data.

The qualifier is simple. The account = Mark. I put no qualifier on the booking.

What am I doing wrong?

2

Your Accounts table should have a foreign key i.e. a unique number for each account. The Accounts table and the Bookings table are linked through the use of this unique key, retrieving all of the records for a particular Account is a simple matter of asking for all Bookings that have a particualar Account number or range of Account numbers.