Search results

Hello, In designing my db, I organized my relationships window just right to allow a good understandable view. When opened up with the front end, the relationships remain of course, but the layout of the relationships window definitely did not remain. All the tables were just piled up and...

Hello, I have a basic question about choosing the primary key for a table. Now I am not really concerned on the particular field(s) chosen to be the primary key, but rather the potential states, if you will, that the key can be in. Say I choose a multiple field primary key for a contact table...

Database structure (many/many to many issue??) Hello, I am looking for someone's professional opinion to help me clear up some unresolved technical issues in my mind... =P Ok, I have a contact management database that would seem really straightforward to me except for the fact that I am dealing...

Hello, I have a pretty basic question about creating relationships in Access. When in the relationship window that shows all tables and associated relationships, I am a bit confused as to whether you are to drag the parent field to the child field or vice versa. When trying both, it appears to...

Quick DLookup question and "=" vs "<>"?? Hello, I am rather new working with DLookup. I don't seem to be having any problems really with it yet, but I am only checking to see if a particular value is null or not. Will DLookup return an actual value is desired? If so would it be the...

Hello, (my first post woo hoo!) :) I am trying to find a specific value in a recordset which will determine whether I add a new record or not when transferring data from one table to another. I am wondering if there is some sort of "search" command available rather than looping through the...