Help on how to make a relational database
I have used FileMaker a few times before to make custom databases from scratch for a few different things but they have been what I think you call "flat" databases. I now need to make a relational one and I am really struggling. I have tried to self-teach myself and but haven't got any further than learnt how to create relationships between tables.
What I am trying to do is make a database for a list of artworks but then have it so once you enter/select the artist's name it brings up or goes to the details on that artist - so the info on the artist is entered once but might be used by a number of records.
I am using FileMaker Pro 9 on Windows Vista.
Thanks so much.