Hi, I have downloaded a trial version and am trying to built a simple database. I have an orchard with different blocks. I need to record management information. I have two tables one "blocks" and another "events". I need to be able to select which blocks an "event" belongs to and display this as a list on the event page. I have read the user guide and can make this work with one related record but can't find how to select and display multiple related records. Thanks for your patience...

You have what's called a many-to-many relationship. For each block, over time, there can be many events. And you have said that each event has many blocks. So, you need a table that resolves this many-to-many, a join table. Call it whatever you want, EventBlocks, and have it store the EventID and BlockID. Then, on the Events form view create a portal to this table using the relationship Events to EventBlocks by EventID.

On the Block form view, create a portal, if you want, to the join table by BlockID.

You also have a one-to-many relationship btw orchards and blocks. So create a portal on orchards using the relationship orchards to blocks by OrchardID.

Search the forum for "join table."