linked tables

G

Guest

I have two tables: one has the main information (names, address, etc) and the
second has (or will have) the details: children's names, ages, etc. So each
record in the first table will have multiple records in the second table. I
know how to set up the key field, but where do I go from there? The first
table is done. How do I enter data into the second table?
 
P

PC Datasheet

Hi Julie,

Use the form wizard and create a form/subform combination. The main form
will be based on your parent table and the subform will be based on your
children table. Follow the wizard's instructions. When done, you will have a
form showing the parents in your parent table and you will be able to enter
new parents. You will also be able to enter multiple children for any
parents in the subform. It's very easy to set up!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is Access right for what I want to do? 0
Don't understand table link 1
Sub Forms 7
Contact database - linking tables 1
Adding fields to existing table from another table 3
acnewrec? 1
Pop-up form that creates record that links 1:1 to main form 0
Access Sorting and grouping using multiple tables 0

Top