want to combine 4 tables. How?

[krempch]

:bang: I have 4 seperate medical record tables in my database. All have the same fields and keys - were intended to track specific conditions (chronic vs accute, for example). These all display in their own portals.

Now, the boss has decided this is too complex, and wants to combine the data into one table.

I'm new at this ... struggling ... Is there a way for me to create this new combined table without exporting the 4 existing and then importing them back one at a time? Thanks.

[bigmac]

You can make a calculation perhaps

What's so bad with exporting and importing again?

[gdurniak]

your boss may be right

in one table, create a new text field, called "Condition", with a drop menu

Use "Replace", to set this field appropriately in all records

then, import the (hopefully similar) data from the other three tables. After each import, replace "Condition"

greg

[Søren Dyhr]

your boss may be right

in one table,

Big applause here, it's usually the other way 'round:

http://www.nabble.com/Aggregating-numbers-from-different-tables-to18298654.html

--sd

[LaRetta]

Boy, you got that right, Soren ... I've had 23 Act Contact Management databases to combine before; duplicates all through. Try combining something like THAT, particularly their activities!! Three cheers for combining!! :wink2:

[krempch]

Export/import it is, then.

Was hoping there might be an internal answer, like a join table that would ensure data got to the right fields.

Easy to finger check an import if you don't pay attention. Maybe I'll experiment with cut and paste to a table Layout ... just for yukks.

Thank you.