Relationships - "One To Many" relationship

[MrAlbionsaint]

Filemaker sucks ass!

Access FTW!

[PaulAnthony2009]

this guy sux as a tutor

[hdyrusli2703]

@goodresonance yeah...

[Respiculous]

You're a great guy for making these tutorials. Thanks so much:)

[k4tay]

I have an issue I cannot quite find the answer for. I have 2 tables.

SCHEDULE (ID,DATE, TIME,LOCATION,HOME_TEAM, AWAY_TEAM)

TEAMS (ID,TEAM_NAME)

I want to create a Layout for the TEAM and have a portal that shows the schedule for that team in Chronological order but I cannot get the relationship link right. I can obviously link team to home team and the portal shows all home games or link it to away team and it will show all away games. How do I link it to show ALL games?

[Geethan500]

what i dont want.. People going on and on and on about one thing. All i want is a fst way to find out to do it to finish my homework,. but finally soemone done it thanks so much. :P

[purple375]

it's easy

thank you :)



[lSaif]

But how do we figure out what relationship to link to what.... please help

[SaturnProds]

that, my dear listener, is a matter of logic. it's too broad of a question to answer without knowing the exact structure you want to create.

[blewvelvet]

a Film production database- have a "PROJECTS table" and a "CREW table".

PROJECTS layout I have setup 6 day shoot. Each day has 2 film crews at different location. 20 positions need to be filled per unit (40 crew members a day!) Many fields in PROJECTS per position / per day (240 individual slots) with a relational drop down menu from my Crew table..it all works and I can select a producer/dp..etc. However, the portal setup back on CREW table doesn't show projects Ive selected them in.

[RoastLambShanks]

hi, how do I add 'customers' to a project, where the customer already exists. I do not want to create new customer, just add or delete existing customers to and from a project. cheers.

[SaturnProds]

Hello. 6:00 on covers this.

[sjcoelho1]

Hey, Thank you so much! i am so new at this and your tutorials help so much.

[andrewapodaca]

thanks for the video.

On the second TO, you showed (4:58) the addition of what appeared to be the customer name. At 6:20 the line item in portal is showing as customer number? Can you elaborate more on this? thx. a

[knichani3188]

hey, thanks for the wonderful video. learnt a lot from it. i understood how to relate fields, but in case i want to relate my stocks, how can i relate the fields and make the stock correspondingly reduce (delete) the stock from the related layouts? hope you understand my question?