Show related data in layout (simple, right!?)
Desc: Layout with table data, e.g scheduled school dates, their location, cost, etc.
Desc: Layout with table data for that school day, e.g. how many students are signed up, what level they are, (will also have what happened that day, etc.
What I did:
1. I created a relationship (presumable correct). Staring with the primary key for T34_School_Dates (ID_School_Dates)
2. I created a foreign key in T35_School_Day: id_school_dates
3. Linked them up, and checked "allow creation of records....."
4. Pulled into my School Day layout, the field "Date1" from the related table.
Doesn't show data.
I'm curious if the keys were setup correctly?
When it wasn't working, I changed them back and forth between text and number. Here's what they are currently
PK: ID_School_Dates - text, Auto-enter Serial, Indexing (minimal)
FK: id_school_dates - text, Indexed (all)
Shows no data in browse mode. Field is set to display in browse mode.
Relationship setup. Is it right?