I am creating a website to browse, search, update and insert into an Access database.

My problem is this:-

I need to have an input page containing all the fields from two linked tables. One table has the one relationship where there can be one letter and so contains all the unique letter details.

The other table contains the multiple addressees that the letter was sent to.

So as you can see each letter can have many addressees and therefore I only want to enter the unique details once and with each of the addressees. Much like a form and sub-form in Access, where all of this can be entered into one page.

I have a few ideas how to do this but none of them are elegant solutions and I am looking for the best way to do this.

The database cannot be amended directly from the server as the personnel who will do this do not have access to the server.

Any ideas would be greatly appreciated.

Thank You

H