Creating a drop down list in table B from records entered in table A
We are pulling our hear here trying to figure out how to create a drop down list of data entered into a table. We are new into filemaker and the database world so apologies if this is clear somewhere else and we can't find the source. After 3 days we have decided to post a query :-)
We have One table where we are entering data (called: Competitions) and we need to enter several awards into each category, but each competition has several awards (all different). We also need to categorise the awards. So the idea is to have a competition profile and then be able to link several awards, therefore we need a drop down list (or pop up) that populates the data entered in the Competition Table. We know how to create the drop down value list but when we try to use a table as lets say "value list" it doesn't work at all. It is obviously something very small that we can't see at the moment... any help would be very much appreciated!!
We are using Mac Os and File Maker Pro 10.
Elora & Ciara