I hope I can explain this right...

Perhaps it would be helpful if I gave you the real world application.
What this layout does is allows a printed report for recording artists
to view their media interview schedule for a given day.

The interface includes the following fields(shown as Title-- field
name);
Call Time-- Artist1CallTime1
Call Sign-- Artist1CallSign1
Contact Name-- Artist1Rep1
Phone-- Artist1Phone1
Show Date-- Artist1ShowDate1

To explain all the 1's, this application allows for as many as 6
individual artists to view as many as 6 interviews on a given day.
Each artist has his/her own interface layout with the changes being;
Artist4CallTime1 or
Artist4CallTime2 or
Artist2Phone3 etc.

Now for the real question. The printed report needs to contain all the
above fields and adding 2 more fields named;

Show City-- Artist1ShowCity1
Venue-- Artist1Venue1

Since phone interviews are normally scheduled days in advance I need
for the printout for today to show the interview schedule for future
shows and I am trying to get the 'Artist1ShowDate1' field to search
and insert the 'Show City' and 'Venue' fields on the printout.

In order to visually help I have placed a couple of screenshots at
www.rocktour.net/_fmp/media_page.htm.

I'm sure this is a very easy process and I cannot help feeling like a
dummy for asking it but these relationships, lookups and searches
baffle me to know end.

No wonder my Dad always called me Dimwit...

As always, thanks in advance,
Charlie

I'm not sure I completely understand the question. You have a data
entry screen with five fields. And you have a print screen with seven
fields.

Is the problem that you need the city and venue fields to fill in
automatically, but they are not? Where are they supposed to fill in from?

Charlie McPherson wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance

Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote

Sorry about the confusion.

Everything is set up according to date. In other words, for each date
entered you have one set of venue records, one set of hotel records,
one set of travel records and one set of media records.

There is yet another layout that has all the general venue info
fields.

The name of the layout is Venue Information

The names of the fields are;
Venue Name
City

These are the 2 fields that I need to be automatically entered on the
printed report.

In order to minimize the number of fields on the artist's media
layout, I placed the 'Artist1ShowDate1' field on the Media Info
layout.

I need for FMP to read the date that is manually entered in this field
and search and auto-enter the city and venue names in the fields
located on the printed report.

I have added a screenshot of the Venue Info layout to the web at
http://www.rocktour.net/_fmp/media_page.htm.

Hope this helps...
Charlie

Create a relationship from Artist1ShowDate1 to the date field in Venue
Info. In the Define Fields dialog, make the City and Venue fields in
Media into auto-enter lookup fields based on the relationship into
venues. Whenever the date is filled in or changed in Media, the Venue
and City info will update automatically in Media.

Charlie McPherson wrote:


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance