showing multiple related records

[fiunary]

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...

[bcooney]

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."