multiple databases

[lkatz1]

Is there any way to have 2 databases with simular fields and remove the duplicate name which are in both databases?
also, is there anyway to print or export both databases into 1 ascii file & they shall be sorted together by lastname etc?

[forskare]

RE: multiple databases

David,

Is there any way to have 2 databases with simular fields and remove the duplicate name which are in both databases?

Yes there is. Are you referring to separate databases or 2 tables within the same database?

also, is there anyway to print or export both databases into 1 ascii file & they shall be sorted together by lastname etc?

Combine the tables or if you're refering to actual databases, into one table or database. Then do it.

kenn

[lkatz1]

RE: multiple databases

Again we have 2 dbf files and we don't want to combine them as 1 dbf file so how do we do the above items questined please explain

[Tom Cone Jr]

RE: multiple databases

David,

DBF files are called 'tables' in Alpha Five.

It sounds as though you want to remove records (not names) if the field value in the Name fields in each table match each other. Is this right?

If you remove duplicate records from both tables, as you say you want to do, you won't have them either table. Is this what you want?

More details please.

-- tom

[whanigsberg]

RE: multiple databases

David,

I assume you have two tables with some records appearing in both and you want to combine the tables without having duplicate records.

If so you have two options:
-append table two to table one; create an operation to mark the duplicate records and then (after inspecting them if need be) delete the marked records.

or

-create a subtraction operation to subtract table two from table one and then append the result table (a new--third--table) to table two.

You should read up on operations:
append
mark duplicates
subtract

Bill

[lkatz1]

RE: multiple databases

This is right what you explained but we still don't want to combine we still allways to keep seperatly only not the same names in both
also, sometimes we want to combine them only for printing they shall be alphabatized

[whanigsberg]

RE: multiple databases



david,

"also, sometimes we want to combine them only for printing they shall be alphabatized"

Consider keeping one big list and runnning queries to separate out subsets of records.

Bill

[lkatz1]

RE: multiple databases

This is complicated because we exporting to ascii for palm and there no way to sort them in the palm as seprate query or tables after they are combined

[RJGowan]

RE: multiple databases

If you want to maintain the 2 DBFs separately for operational purposes and only combine them for printing purposes, then all you need to do is
- create a THIRD table for this temporary use,
- append the reoords of each of your 2 operational tables, and as Bill suggested:

-mark the duplicate records and then (after inspecting them if need be) delete the marked records.

This could all be combined in a single operation on the third table.

[lkatz1]

RE: multiple databases

This is a good idea but the only problem we would like to eliminate them from the original table

[forskare]

RE: multiple databases

David,

We are a bit confused as to what you have and what you want to do. I know we can find a solution for you but first:

1. please tell us what is the purpose of each table;
2. what fields are in each table you want to use to print;
3. what fields are in each table you want to export;
4. What else do you want to do the the data in each of these tables.

The more info you give us, the easier it will be to help you.

kenn

[lkatz1]

RE: multiple databases

the fields are
first , last ,add,code,city state,zip,zip4,tel
these fields are in both tables, but the names of each table are as catagory one is example a family list and one is a niegbhors list 1 list contains 1000 names 1 list contains 1800 names we then export the lists to our palm and when ever any change is done it's on the palm we sync daily and import all changes to original table, but when we want to print sometimes we will only print 1 table sometimes both (then we would like to have them combined) but we never would like to have any name in both tables each indvdual only belongs in either one table nobody belongs in both
we also keep in constantly adding names in both tables which maybe somtimes by mistake a duplicae in the same table

[forskare]

RE: multiple databases

David,

If I understand what you want to do, I would use one (1) table. I would also add a field that designates the record for catagory 1 of catagory 2. Consider using a Simple Lookup in the field rule. When you enter the field choose catagory 1 or Catagory 2. Others might suggest other ways to do it, which, could be better than my suggestion.

Then, when you export or print, simply designate which catagory, 1 or 2.

kenn

[Tom Cone Jr]

RE: multiple databases

David,

I agree with Ken. If it were me, I'd use one table to track both lists.

To move data from the pda devices, I'd create separate append operations to pull only new or changed records into the master table from each pda.

-- tom

[lkatz1]

RE: multiple databases

As we link with the code field which almost corresponds to the recno and sometimes we print by recno this is going to make a slight problem to combine