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

Table update

P: n/a
Hi!
I have a problem with a small app.
I have a membership table and a payment table, they work ok together but
when I create a new member I want the app to create a new record in the
payments as well otherwise I cannot enter payments.
I have never done anything like this and wondered if someone could help.
Lucy
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hello, Lucy!

I think you'll find it easier to work in forms than directly in the tables.
First, define a one-to-many relationship from your membership table to your
payment table.
Enforce referential integrity with cascade updates.
(If any of these terms is unclear to you, try the Access Help file, or
post back here.)
Now you can create a form from your membership table, with a subform from
your payment table.
Whenever you add a record to the subform, it will automatically pick up the
appropriate ID from the membership table.

HTH
- Turtle

"lulupuce" <L.*******@kent.ac.uk> wrote in message
news:c5**********@athena.ukc.ac.uk...
Hi!
I have a problem with a small app.
I have a membership table and a payment table, they work ok together but
when I create a new member I want the app to create a new record in the
payments as well otherwise I cannot enter payments.
I have never done anything like this and wondered if someone could help.
Lucy

Nov 12 '05 #2

P: n/a
> I think you'll find it easier to work in forms than directly in the
tables.

Thanks,
I am working in a form, the problem is that the subform doesn't for the
moment pick up the new record, but I haven't done the referential integrity
and that will probably do the trick.
Lucy

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.