splitting table into related table

[Dylan Snyder]

okay, last question. I promise. You all have been so helpful, though...

I have been given the assignment of splitting down a table into two more tables(three in total). My question is this: Could I use the Table analyzer? If so, what are the shortcomings? I would like to have the other tables referenced by the key of the original table instead of a lookup field, whioch I'm not sure if I can do in the analyzer. What attracts me to the analyzer is that it would make the needed queries to join the new tables. If I don't use the analyzer, would I use a make table query to accomplish it? If so, would I have to change every existing query in the database that used that old table?

I know it's a lot, but any help in pointing me in the right direction would be much appreciated

 

[Simon_MT]

If the relationship to between the Tables is one to one then why are they being split? Yes all the existing query would need to changed that use the original table as fields will be missing as they have been hived off. To make things a bit easier you could always create a query that includes all three tables.

Simon