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

REQ Help: Adding a new record to a table which is related to a selected record

P: n/a
Hi,

I have a table that contains the address data of my clients. I
have another table that contains project data. It is related to
my clients table. 1 client can have multiple projects.

Now I made a form that shows 1 client at the time and I can
search for clients, add new clients, delete clients (who wants
to do that though) and so on. The form also show a sub-form for
all the projects that belong to one client. Here comes my
question: How can I create a button in my form that adds a
project to the selected client?

Can someone please help?

Regards, Peppie

----------------------------------------------
Posted with NewsLeecher v2.0 Beta 5
* Binary Usenet Leeching Made Easy
* http://www.newsleecher.com/?usenet
----------------------------------------------

Aug 29 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
How can I create a button in my form that adds a
project to the selected client?
Do you have something against using a subform? If you create a
relationship between the two tables and then add the subform, the
linkmaster and LinkChild fields will already be populated. Then all
you need to do is click the new record button in the subform.

Too easy, though, right?

Aug 29 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.