elevins
Technical User
- Jan 24, 2005
- 18
I have two tables:
The fist table is a 'Software list' table, which has 3 fields; SoftwareID, Program, and Version.
The second table is 'Software_ID',which I would like to have 2 feilds; ComputerNum and Software ID.
Basically I have several computers and I want to keep a list of ALL software on these computers. So far there are 400 different software types.
How can I update the 'SoftwareID' table to replace the 'Program' and 'Version' Feilds with the SoftwareID field?
The fist table is a 'Software list' table, which has 3 fields; SoftwareID, Program, and Version.
The second table is 'Software_ID',which I would like to have 2 feilds; ComputerNum and Software ID.
Basically I have several computers and I want to keep a list of ALL software on these computers. So far there are 400 different software types.
How can I update the 'SoftwareID' table to replace the 'Program' and 'Version' Feilds with the SoftwareID field?