Sorry about all the reading, but it really explains my question.
MS Access Table relationships
Question 1: When I make a database and tables are NOT ODBC linked to SQL tables, it's no problem to create table relationships, like main table = 1 to secondary table = Many... NOW, when I create a database with linked tables to the SQL tables, I cannot create the 1-many relationship in the database. I understand that the SQL tables are secondary tables which makes it so, I cannot create this 1-many in the MS Access db.
Question 2: how do I create this 1-to-many relationship using linked tables. The goal is to have a form with a list box, user highlights item in list box, click a hyperlink to open another form which has a source of a query! This query is created from the secondary table (the many) and will present all the many records, related to that one the user highlighted from the list....