Adding reccords in tables automatically

katiekat · Sep 20, 2000

I have 4 tables. Tables A,B,C,D.

tD
^
^
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!
Thanks!
Kate
[sig][/sig]

kjonnnnn · Sep 20, 2000

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? [sig][/sig]

katiekat · Sep 20, 2000

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? (-: [sig][/sig]

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Adding reccords in tables automatically

katiekat

Technical User

kjonnnnn

MIS

katiekat

Technical User

Similar threads

Part and Inventory Search

Sponsor