Very Computer

Thank you so much.

Ken

Hi Karo,

I have done this in the past.

You will need to create a couple of relationships (One is a self
relationship and will be external to the 2nd file).

Create a new layout and place both Portals on it. Make your Portals big
enough to display all of the fields to be compared.

Also, John Mark Osborne has a tip file called Portal Comparison or something
like that at

http://www.fmfiles.com/tnt5.html

HTH

Lee

Quote:> Hi,
> I have 2 separated databases with fields for dates. I can sort each database
> by date which is great. But I would like to see a list of all dates of both
> databases on one page. Is this possible? I could either be a layout in one
> of the two databases or it could be a completely separate third database.

> Thank you so much.

> Ken

create 2 value lists, each based on one of the date fields.
create 2 text calc fields, and define as ValueListItems (dbname, valuelist),
unstored
quote the VL name (""), and I usually use Status (CurrentFileName) for the
dbname

Chris Brown
Dept. Neurosurgery
University of Adelaide

Quote:> Hi,
> I have 2 separated databases with fields for dates. I can sort each
database
> by date which is great. But I would like to see a list of all dates of
both
> databases on one page. Is this possible? I could either be a layout in one
> of the two databases or it could be a completely separate third database.

> Thank you so much.

> Ken

as the request was for a list of all dates, one might interpret this as
distinct from a 'list' of all records having dates

if you want only a single iteration of any given date, then value list
if you use portals you will list ALL records, and hence display  multiple
records for  agiven date, if they exist. Unless of course you employ some extra
manipulations to exclude duplicate dates from the portal...

Chris

Chris Brown
Dept. Neurosurgery
University of Adelaide

Then create a layout in database A and put two portals in it - one for
each of the two relationships.  Put the date fields from the relevant
files in the portals and Bob's your uncle!

I don't know how familiar you are with talk of portals, relationships
and the like.  If not, the above probably won't make much sense -
spend some time with the online help on these topics - or wait for
someone wiser and more patient to do a better job of explaining it
here :)

Good luck.

Robert

--
regards

Chris

Chris Brown
Dept. Neurosurgery
University of Adelaide