Search results

Yes A is the main table. Yes absolutely right don't care if someone is in B but not in A and vice versa. Yes you could say that! I think you're right on the left join query!! I'm going to research it properly tomorrow :)

Hi Plog, thanks for not giving up on me yet! Purpose: keep a clean database of students attending a college. Basically, the end outcome is to have a nice form which will display the fields: Social security number (PK), first name, last name, address and email address. As students enter...

Table A: Social security number (PK), first name, last name, address. Table B: Social security number (PK), email address The issue is that I have two tables with records in Table A with no relationship to Table B? e.g. the PK 111 in Table A does not have a corresponding PK 111 in Table B...

Thanks guys!! Am I correct in assuming you cannot enforce referential integrity when establishing a relationship between two tables when there is some data in Table A that Table B does not have and vice versa? How would you recommend I approach a simple problem as: Where Table A has data that...

Hello All, My name is Harry and I am a student at QMC. I am an aspiring Access Wizard :P like some on this forum! I hope to learn a lot by browsing around, asking questions but also in the weeks to come giving back to the community and answering questions as well. :) Kind Regards,

Hello All, I've been trying to learn Access lately and have come across a few different scenarios where I am slightly confused. Maybe someone can clear it up for me? :) Problem: There are 2 tables: Table 1 has National Insurance Number, first name, last name, phone no, address. Table 2: has...