Making a field in one table populate data in another table

[VTO]

Hello,

I am building a database and I have two tables one name computers the other disk drives. In the computers table I have a fields name disk drive serial number, disk drive type, disk space, and service tag. In correlation to that my disk drives table I have fields named serial number, disk drive type, size, and location. I want to know to make it so when the serial number for the disk drive is entered into the computers table in builds a new line in the disk drives table and populates corresponding fields with appropriate data

Computers Disk Drives

Disk drive serial --> serial
Disk drive type --> Disk drive type
Disk Space --> Size
Service Tag --> Location

[pbaldy]

How about:

http://baldyweb.com/Autofill.htm

[June7]

Why do you want to duplicate data in multiple tables? This violates basic relational database principle.

[VTO]

I still really new to using access and don't have much knowledge on where things are located could you break it down alittle more I can tell you that I do want to save the related info

[June7]

Have you studied an introductory tutorial book on Access? Have you done any research on database design and normalization?

[pbaldy]

I still really new to using access and don't have much knowledge on where things are located could you break it down alittle more I can tell you that I do want to save the related info

The code would go here, if you actually need to save the extra fields. As June7 and my link suggest, you probably shouldn't.

http://baldyweb.com/FirstVBA.htm

[VTO]

Pbaldy thank you so much you guys have been a big help

[pbaldy]

No problem.