Is it possible to have a drop-down related field in a Custom Dialog
Box?

I am trying to work with a database built by another. The problem is
as follows- I'll use an analogy of a movie rental place to make things
clear:
Table for movies
Table for contacts
Script for invoices (although no table for them, which is strange I
think)

The script asks via custum dialog for a unique number or name of the
invoice
The script asks via custum dialog for the name of the contact
(I would like to have a drop-down menu from the full name field in the
contact table here. And have the contact address information paste in
via a lookup. Is that possible? Currently you just type in text)
End script

New script in form of a button to add movie to invoice
it pastes in the invoice name to invoice field

New script to Print invoice
makes it a PDF

I'm confused about the lack of table for invoices. I'm confused as to
how to get a drop-down from contacts to appear in a script that is
running on the movies table.

Can anyone advise?

I REALLY appreciate it!!

Heather

Can you have a drop down in a dialog - NO.
Can you put a drop down on a field in Movie - YES, format the field as
a valueliest.
Can you have the fields in movie lookup based on the contact name you
select - YES they're just straight lookup fields based on name.

heath wrote on (9/23/2005):


Consider converting the routine from opening a Custom dialog to opening a
new window, using a layout with the appropriate field formatted as a
drop-down.

Look at Windows Script Steps in Help for the controls available.

Tip: if the main window is maximized, opening another will cause the main
to resize considerably smaller. This can be avoided by making your main
window just one pixel smaller than maximized. You can size the window with
the Adjust Window script step in an opening script, and maybe place the
same step at the beginning of any other script, in case a user has changed
the window size or position. Use a set of global fields to store the
specifics of any window whose size and position you want to control.

Matt