Search results

I have a (fairly) simple database with; Main table (call this DNT) a subtable (DRT) with full referential integrity to DRT a 3rd level table (D2T) with full ref integrity to DRT but is a multi - multi as its only other field (apart from date and time stamps) is linked to the primary key...

I am suffering novices frustration that I can't get something simple to work ! Using Access 2010 database that has been downgraded to 2007 (I imagine from an Excel import) I have created a table (lets call it Main Table (MT)) from Excel, moved the autoinc. field so as to use the first data...

Using Access 2010; starting point for this post was 2011 post "Multiple Column Lookup Display- table & form" . I have a lookup table with 4 data fields whose values I need to associate with a Master record in my "Main Table". (The main table was initially created by importing an Excel...

I have worked for many years in documentation & data management and have specified many databases, small and large, but am not a programmer. All my personal databases still run in Borland's Paradox (that uses a C++ based ObjectPal language). I have used Access on and off for the past 13 years...