Please Help With This Access Question

[Michael J. Savage]

Hi All,

I posted yesterday re appending a table to another but it seems I was
asking the wrong question.

What I'm trying to do is open a client information table and, with a
click of a button, append a table of work descriptions (a template) to a
table of client work descriptions, which I understand how to do.

What I can't understand is how to tie the work descriptions to the
client information (they are separate tables) yet have both tables
appear on one (tabbed) form.

I know I'm asking a lot, but I'm trying to solve a problem and learn
more about Access at the same time. I enjoy working with Access, but
sometimes I'm in over my head. I use Access 97 and have no training
besides reading "Mastering Access 97".

Thanks in advance,
Mike

[rkc]

"Michael J. Savage" <mi**@mjsinspections.com> wrote in message
news:MP************************@netnews.comcast.ne t...

Hi All,

I posted yesterday re appending a table to another but it seems I was
asking the wrong question.

What I'm trying to do is open a client information table and, with a
click of a button, append a table of work descriptions (a template) to a
table of client work descriptions, which I understand how to do.

What I can't understand is how to tie the work descriptions to the
client information (they are separate tables) yet have both tables
appear on one (tabbed) form.

Create a subform to display the work descriptions and link it to the
main form via ClientID or whatever field links the two tables. If the
'magic wand' is highlighted when you place the subform, a wizard
will walk you through the linking process.