Hi, I am still trying to figure out the most important part of relational database design. Now I am much older and I thought wiser but am still stumped when it come to making relationships between tables. I started with MS Access a long time ago and had some of those 700 page books and ended up with a flat file single table database in the end as all that foreign key and 1 to1 , 1 to many, and many to 1 stuff didn't sink in. So now I am back with another go at it. I have put together a single table flat file db using LibreOffice Base and want to split it into multiple tables and make it relational. I have split it up and don't know which field should be in table and table two. I have ordered an older version of MS Access (2010) that will be here soon. I hope somebody can get me over to the dark side. I am in Florida.
