Two database with record lookup and Import?

[Devin]

I have two databases! "A" and "B" Their not realy related but I need database "B" to be able to see when new records are created in "A".

I would like for Data Base "B" to show how many records are new in "A" and then allow them to import some of the data.

My thought was to make a field in "A" called "import" and give it a auto value of 0.

Then have "B" find the records in "A" that have a value of 0. Then allow them to import certain data from the "A" record, upon import it would change the value in "A" for that record to 1.

Not sure how to make this happen or if I'm even thinking this is the right direction.

Any help in making this work or a better way please let me know.

Thanks

Devin

[comment]

I am not sure I follow this (it's always confusing with abstracts like A and B ), but it seems you could have the A table auto-enter creation timestamp. When importing, set a global field in B with the current timestamp. For next import, find in A records whose creation timestamp > B::gLastImport (this could be by a relationship).

[Devin]

OK... Two database. One called Plating and the other called warehouse.

I need away to let the warehouse know that there are new records. This can't be an auto import because the way the like to name and file jobs is not the same plating names them.

When plating make a new record I would like it to show in the warehouse how many new records and then the can pull it up so see the list of new records so that they can import it, Right now by hand.

I guess where I'm stuck is how to set up the relationship between the two.

Devin

[comment]

I think I have already answered that - the relationship is:

Plating::CreationTime > Warehouse::gLastImport

This shows all Plating records created after the last import.

[Devin]

OK, I understand what your saying now, but I don't think this will work

We have two people that use the warehouse db. They will import the records from plating that pertains to them. so if one person checks and it only imports one record, and the other person checks he will not see his stuff.

I hope this make more since, and thanks for your help!

Devin

[comment]

I am afraid you've lost me completely.

[Devin]

I got it to work! I took your thought but did not use a date! I used your example to solve my problem.

Thanks for helping, even thought I lost you.

It was eaiser then I thought.

Devin