Combine Table Structures ? 2

[Raccoon]

What is the best way to combine the fields from 3 tables into one new table? I want to keep them in a dbc as I don't want to lose my long field names, and I sure don't want to manually build the new tables. Fields of like names should be in new table just once.

Any ideas?

 

[DSummZZZ]

My response is "Why?". It's usually better to have related data in separate tables to prevent bloat of tables that have fields which may not be filled in for every record.
That said, you could create the new table, then open the other tables and set a relation, then SCAN...ENDSCAN through them, using the data to either append records to the new table, or a SCATTER / INSERT INTO construct.
Dave S.

 

[Raccoon]

What you say sounds good, but.... I want to take the resultant table, load it with a subset of the original tables, and use it to drive a list. I can't get a list to use related tables.

 

[ramani]

HI Raccoon,

I suggest create a view connecting all three tables and save it in yout DBC. There is no table size overhead, since the views are virtual. You can use the view designer/wizard.
After saving the view in your DBC, you can use it as if it is a TABLE... USE myView IN 0 ALIAS myView... is acceptable.
SO you get the benefit of both world.

I have also posted just a day back.. how to set the views name property etc.. by a simple utility. (Code provided by me in that).

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[Mike Gagnon]

Raccoon

Create a view or a table from an SQL Statement combining all the fields together. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first or check this link

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[Raccoon]

Ahhhh, knew I could count on the pros, thanks.