Request for help. Im a beginner.

[Marc Janzs]

Could somebody explain to me the following. a have one Table called "Projectname" and one "Projectaddress" sometimes i have a projectname but not the address at that moment. So the autoincrement on the primary key in projectname keeps increasing. When i use a inner join querie on the primairykeyID it happens that addresses dont match up with the projectname as i have added the adresses later. How do you make sure that in the address table an empty row is added that keeps corresponding with the first added projectname. I tried everything but cant figure out how this is done. The best would be if i could add the projectname to the addresstable and then run a querie on projectnames in both tables.

thanks for your help