AnsweredAssumed Answered

Primary key

Question asked by sherwood on Apr 3, 2018
Latest reply on Apr 3, 2018 by philmodjunk

I know this is basic but i skipped a few years and apparently some training. I am moving a database from Approach to Filemaker. I understand i need a primary key which will be "foodbank" but i also need a second primary key for "county" to which all the data will be directly linked. do i create a spreadsheet with the counties listed and the foodbank name as the primary key? I would list  the counties as the primary but the main reports will be run by foodbank, there are times when i will need to pull county specific. there is one county that will have foodbank listed twice. does this make sense? and if so could you send a link possibly to a short training video. thanks for all your help.