Recent content by abcdef

Thanks Galaxiom, You're right that the LinkChildFileds and LinkMasterFields don't exist. If I run the code without those 2 lines (so just update the Subdatasheetname), the code runs through all the tables and links them like I want, but changes the Subdatasheet to only the table from the last...

Hi jdraw, I looked into Forms and Subforms and I'm not sure that's what I'm looking for. I will be the only user of the database and all of the data is already being imported from excel. To put my question simply, I am looking for a way to automate the process of setting one table as a...

Yes, I think that sound right. Would I need to make a subform for each of the sheets to be inserted into the main form? How would I code this through vba? Thanks

Thanks for the reply. I basically have multiple tables that I want linked to a main table. The database is used for viewing purposed, and I would like to be able to open the corresponding subdatasheet for any row in the main table by clicking the + sign. Thanks

I have a main table and multiple other tables that I want to link to each row of the main table. The main table "Data" consists of columns (Name, x, y) where "Name" is the primary key and all values are unique. Each of the other tables have columns (Name2, z) where the value of "Name2" is the...