Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Adding reccords in tables automatically

Adding reccords in tables automatically

Adding reccords in tables automatically

I have 4 tables. Tables A,B,C,D.   
tA-----------------tB >>>>>>> tC
Table A and B are connected by a one to many relationship by a customer id #.  Table B is connected to tables C & D by a one to many relationship with a contract #. I was wondering if there is any way to fix it so when I entered a name and ID # into A, it could create a reccord in B with that information.  Likewise for B.  When I go to B and enter contract #s, it would create reccords in C and D. I hope this makes sense! Any insight would be appreciated!

RE: Adding reccords in tables automatically

What if you created a field in Table B, use the LOOKUP feature to see the fields you want in Table A....?  and the same with Table B,C, and D?

RE: Adding reccords in tables automatically

Thanks! That's a really good idea. I was hoping to have it done for me though.  So when you are entering info into a form, you can just open up the next part and it will all be there for you. That way you don't have to re-enter info all the time, you know?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close