By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,028 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Please Help With This Access Question

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.