Building List

[Slobey]

Hi guys,

I am not sure this is where I should ask this but here goes.

I have 5 fields labled Bldg_1 through Bldg_5. Some records have only bldg_1 some have more. I need a report that has all buildings sorted by building number.

How do I find all the buildings from the 5 fields and display it in a single field to show all building numbers?

[T-Square]

You probably don't know it, but your question is more about relationships...

You need to normalize your data so that the building information isn't put into different fields (Bldg_1 through Bldg_5). You normalize by creating a separate Building table that has bldg Number (1 through 5) and SiteID (assuming the main table is some sort of site-oriented table), make a link between SiteID in the site table and the SiteID field in the building table, and put whatever building-specific information in thebuilding table. Then, you make a report in the building table that will list each building in its own line.

Scout around the forums for more about using arelational structure. There's a lot here about how to do it.

I hope this gets you going...

David

P.S.: To anticipate a question down the line, there are ways to limit the number of related building records a person can create attached to a given site, and others will be able to guide you there.