Easy Middle Tier Question

[JamesM]

I have an address book app. It has 2 tables, 1 for New Contacts and one for New Phone Numbers.

As a new contact is added, one or more numbers may be added associated with that contact. E.g Add Contact Joe Smith, Then Joe has a work and home number which are added to the phone number table.

I have the app up and running but only in 2 tier format.

If I want to create objects to handle access to the db server, what objects should I use in this circumstance?

For example should I have a contact object and a phone number object?

[alex_read]

Not really, you can store all of the data in 1 recordset.

Take a look at the following in your MSDN help :
INNER JOIN
DISCONNECTED RECORDSETS

I'll try & find a project which I'v used this with & paste some code.