Is it possible to make the records of one table the fields of another table? Here's my scenario... I'm building a DB to keep track of software owned vs installed for a school. As I have the DB designed currently, one table is called tblSoftwareOwned. Here are some of its fields and a sample record. FieldName Record 1 Record 2 SoftwareID MSOffice03 TypetoLearn SuiteTitle Microsoft Office 2003 Type to Learn Manufacturer Microsoft Sunburst Platform Windows Windows The purpose of this table is to keep track of info on each software title. I started creating another table called tblSoftwareInstalled, as illustrated below: Field Name Record 1 Record 2 ComputerName Rm214-1 Rm214-2 MSOffice03 yes yes TypetoLearn no yes The purpose of this table is to keep track of what is installed on each computer. So, as I add new software titles, with my current design, I will need to add a record to tblSoftwareOwned and then also add it as a field in tblSoftwareInstalled. Is there a way to make it dynamically become a field in the second table after I add it as a record in the first one? Or, is there another design that I should be considering? (For what its worth, there are tables in this DB design, such as tblvendor and tblorders - which, for example, keep track of who the software is ordered from and when the software was ordered.) Any feedback would be greatly appreciated.