Showing repeating fields from related table

[Adam Runtime]

Hi

Having trouble with a layout....

I need to show and make editable the data some related tables.

I have Week which contains some Days which contain some Sessions. Day has a number of SessionIDs and Week has some DayIDs. Since I am using repeating values, I can get the sessionID's listed easily, but cannot pull all the other info out ... how do I get the repeating fields out?

eq Day::Session::StartTime

Am I doing this the wrong way???

Thanks

Adam.

[RalphL]

Using repeating fields. Repeating fields violate what is called the first normal form in relational database design. A repeating field should be replaced by a related table.

[The Shadow]

Once you place a related repeating field on your layout, you can choose "Format" > "Field Format..." to show its repeats.

[Adam Runtime]

Well,

I solved this problem by using A Portal, which has in turn caused more problems....

think Ralph is right, I should adhere to db design like I was taught at college!!

Hmmm might need to go back ....

Thanks anyway.