Add New Record Using Data From Another Field

mattcdse

Registered User.
Local time
Today, 23:24
Joined
Nov 23, 2005
Messages
42
Hi all,

I have two tables, A & B, which are related to each other. A is a list of of Image Codes (IC) that are matched with a list of Software Codes (SC). This effectively gives a list of the images available and all the software packages installed on each image. B is a list of all the software packages.

When A new image is created, I would like to be able to just type the name of the new image into a form and then access uses this information to fill table A with the new information. I.E.....

IC-NEW, SC-1
IC-NEW, SC-2
IC-NEW, SC-3
IC-NEW, SC-4
IC-NEW, SC-5

Where the different SC codes are all those that are common to all images. I have marked each software title with whether it is standard or not in a seperate field.

Hope this makes sense,

Cheers,

Matt :)
 

Users who are viewing this thread

Back
Top Bottom