Search results

Thank you for the reply. I may have not been clear in my original post, I haven't started creating the database yet so the structure can still change. My proposed idea is that I use the Archers name as the primary key to make searching easier ( we know the names of the people as opposed to...

I am doing an outline design of a database system to handle the results from an archery competition in a couple of weeks. Currently I have a table with a primary key to hold the information on the competitors (name, age etc.) and this is linked to a table via a foreign key (the archers name) to...

Thank You both of you, that has done the trick brilliantly, and taught me a little about the syntax used. Ben G

Hi, I am building a scoring system for an Archery Tournament and am trying to add some extra validation between two fields. I want to check the contents of one field against another. So if Field A has an even value, then Field B must also be even, and if Field A has an Odd value, Field B must be...