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