How to relate 2 entries in main table to 24 entries in sub table.

Hi!

One ide could be to create a "main OPC-table" relating to both your "primary/bcup" table and to your "24-entry-table"

newTable(newID (PK), etc)

tableOPC(OPCID(PK), newID(FK), Type, Name, System, Location, IP address)

tableTwo(TwoID(PK), newID(FK), NE, NE#, Building, ID, Type, Comments)

It's a bit difficult to read table-names and Keys in your description, but it's a try. If it doesn't work, perhaps someone else has more ideas.

Good Luck, Roy-Vidar

[sig][/sig]

Ruth,

If you understood the previous post from Roy Vidar, you may want to just ignore this.

Otherwise.

What Roy is doing is creating an "intermediate" table. The existing tables exhibit a "many-to-many" relationship, which is not (driectly) supported. Loosely translated, this means that any item in either table may relate to more than one item in the other table. The classic resoloution is to generate a new 'intermediate' table with sufficient information to uniquely identify a one to many relation ship between it and both of the existing tables. In this instance, Roy is suggesting that you would need to generate this table, and modify the existing tables to insert foregin Keys (FK) to relate to the intermediate table.

So, now I think you might be able to do the relationship w/o the intermediate table.

In the 'main' table, seperate the 'Name' field into two fields 'Name' retains the numeric part ("0100&quot while the new field ("PriBu"?) which will contain the "B" or the "P" (we could make this a boolean (Yes/No) where True ~~ "P" and False ~~"B", but the text w/ P/B is O.K.). Now, add a field to the 'sub' table which has the (New) name field (e.g. "0100&quot. Now, the relationship between the two tables is just one-to-many on the "name" field, with PriBu acting to collect/Filter the primary and backup information in the 'sub' field.


[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]