Recent content by MSpoon

The Murph2000 Thanks for following up. I actually referenced the information you sent me and figured it out. :) Thanks again.

Table not linking theMurph2000 The database is attached. Any insights on overall integrity would be welcome. Thanks.

Table not linking the Murph2000 Thanks for the reference site. It was very helpful. Also, I don't feel so bad now that I know the QBE site is ok to use in lieu of the wizard. I will post the database again when I have a few minutes. Thanks again.

Table not linking the Murph2000 Thanks for your insight. I have addressed the primary key issue. I don't know what is going on with my database. If I run queries with the wizard joining tables with the main table Agency, the Agency cells are empty but the other tables contain data. If I...

Dudley Thanks for your insight. Yes, the agencyprogrammes table is the foundation. You advise entering data into this table. Could you explain this a bit more. I assumed that the data would filter from the agency form when the data is entered. Obviously, this is not the case? Should I be...

Tables not linking to query I am attaching the zip file of the database as you suggested. Please note that this is a new database that I am creating. Therefore there is only a few records in there. I have been testing tblAgency and subtblcounselingprogram to see if I could join these two...

Linking tables Thanks Dudley. I will do so shortly.

I am pretty new to creating relationships between tables. I have a main form with subforms embedded. I tried running queries from the main form and they run just fine. I also run from the tables linked to the subforms just fine. however, when I try to run a query for a report that takes data...