[noob] Orientation needed with relating 2 tables

[IAzpiazu]

I am using FMP 9 for the first time, went through the tutorials and user guide. I have a headache and still can't figure out how to do this, which I would hope is quite basic.

I have two tables coming from a CAD program,

Apartment Schedule (story, apartment number, apartment type)

[color:blue]story 1, apt 1, Type A.1

story 1, apt 2, Type A.1

story 1, apt 3, Type A.2

story 1, apt 4, Type B.1

story 2, apt 1, Type A.1

(…)

Room Schedule by Apartment Type (room number, room area, room name, occupancy,etc.)

[color:blue]Type A.1, room 1, 10 m2, hallway, B3

Type A.1, room 2, 6 m2, toilet, B1

Type A.1, room 3, 12 m2, kitchen, B3

Type A.1, room 4, 15 m2, bedroom, B2

Type A.1, room 5, 18 m2, living room, B3

Type A.2, room 1, 9 m2, hallway, B3

(…)

This table can be a single table, listing the rooms for one apartment type after the other, or if there is no better choice it could be generated as one separate table for each apartment type. The number of rooms differs for each apartment type.

And I need to combine information from those to get a Building Room Schedule looking like this:

[color:blue]story 1, apt 1, room 1, 10 m2, hallway, B3

story 1, apt 1, room 2, 6 m2, toilet, B1

story 1, apt 1, room 3, 12 m2, kitchen, B3

story 1, apt 1, room 4, 15 m2, bedroom, B2

story 1, apt 1, room 5, 18 m2, living room, B3

story 1, apt 2, room 1, 10 m2, hallway, B3

(…)

I am totally lost. Any basic orientation will be highly appreciated.

Edited July 1, 2008 by Guest

[Fitch]

It looks like you need to loop through each apt and create a list of rooms based on the apt type. There are a number of ways you could script this, for example:

Go to layout( apt schedule )

Loop

Set variable( $type; apt type )

Set variable( $aptnum; apt num )

Go to layout( room schedule )

Enter find mode

Set field( type; $type )

Perform find

Go to layout( building room schedule )

Import ( *from room schedule* )

Replace( apt num ; $ aptnum )

Go to layout( apt schedule )

Go to record( next, exit after last )

End Loop

Does that make sense? There's probably a more elegant solution but something like this should get the job done, assuming I understood your request.

[IAzpiazu]

Thanks very much. Yes, it seems some script like that should do it. I was not sure whether I was totally missing how to use relationships to get this job done, or I was actually needing some other tools in order to get this job done. Thanks very much again.

Edited July 6, 2008 by Guest